By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. # | 5| val_5| 5| val_5| Both Partitioning and Bucketing in Hive are used to improve performance by eliminating table scans when dealing with a large set of data on a Hadoop file system (HDFS). What does hdfs dfs -du -s -h /path/to/table output? Did this satellite streak past the Hubble Space Telescope so close that it was out of focus? My code is GPL licensed, can I issue a license to have my code be distributed in a specific MIT licensed project? Step 2: Issue a CREATE EXTERNAL TABLE statement. What is the difference between partitioning and bucketing a table in Hive ? Necessary cookies are absolutely essential for the website to function properly. (Apologies for the newb question. Available org.apache.spark.api.java.function.MapFunction. For Big SQL, the CHARACTER_LENGTH function counts characters, and for Hive, the OCTET_LENGTH function counts bytes. tblproperties will give the size of the table and can be used to grab just that value if needed. Find centralized, trusted content and collaborate around the technologies you use most. # Key: 0, Value: val_0 What happened when a managed table is dropped? # +---+-------+ BZIP2. Selecting a random table in Hive with id 5783 and name test12345 from the TBLS table in Hive Metastore DB. Step 1: Show the CREATE TABLE statement Create Spark Session with Hive Enabled 07-11-2018 C $35.26. But it is useful for one table. Based on a recent TPC-DS benchmark by the MR3 team, Hive LLAP 3.1.0 is the fastest SQL-on-Hadoop system available in HDP 3.0.1. Note that, Hive storage handler is not supported yet when How do you remove Unfortunately Settings has stopped? The data loaded in the hive database is stored at the HDFS path /user/hive/warehouse. You can check for tables with this value as false to see if there are any tables in Hive those might have missing statistics. Can I tell police to wait and call a lawyer when served with a search warrant? Who does the voice of Vanessa on Phineas and Ferb? 01:40 PM. It would seem that if you include the partition it will give you a raw data size. Jason Dere (JIRA) . Thanks very much for all your help, Created - edited Whats the grammar of "For those whose stories they are"? It is providing the MySQL solution on top of the HDFS data. However, if someone forgets to set the above two properties the compression is not achieved. Table name: Instead, use spark.sql.warehouse.dir to specify the default location of database in warehouse. Hive simplifies the performance of operations such as: Data encapsulation Ad-hoc queries Analysis of huge datasets But what makes Hive standout? 01-13-2017 # | 4| val_4| 4| val_4| Linear Algebra - Linear transformation question. # |key| value| 05:16 PM, Find answers, ask questions, and share your expertise. Note that independent of the version of Hive that is being used to talk to the metastore, internally Spark SQL org.apache.spark.*). 01-17-2017 What are the compression techniques in Hive? they will need access to the Hive serialization and deserialization libraries (SerDes) in order to Recovering from a blunder I made while emailing a professor, How to handle a hobby that makes income in US. % scala spark.read.table ("< non-delta-table-name >") .queryExecution.analyzed.stats Was this article helpful? For example, SAP SE (/ s. e p i /; German pronunciation: [sape] ()) is a German multinational software company based in Walldorf, Baden-Wrttemberg.It develops enterprise software to manage business operations and customer relations. so the Hive system will know about any changes to the underlying data and can update the stats accordingly. Apparently the given command only works when these properties are available to the column, which is not there by default. the input format and output format. Hands on experience on SQL SERVER 2016, 2014, SSIS, SSRS, SSAS (Data Warehouse, DataMart, Dimensional Modelling, Cube Designing and deployment), Power BI, MSBI and SYBASE 12.5. How can check Hive table size? The cookie is used to store the user consent for the cookies in the category "Analytics". Clouderas new Model Registry is available in Tech Preview to connect development and operations workflows, [ANNOUNCE] CDP Private Cloud Base 7.1.7 Service Pack 2 Released, [ANNOUNCE] CDP Private Cloud Data Services 1.5.0 Released. Other classes that need We do not have to provide the location manually while creating the table. Yeah, you are correct. What is the purpose of this D-shaped ring at the base of the tongue on my hiking boots? One of the most important pieces of Spark SQLs Hive support is interaction with Hive metastore, 09:28 AM, Du return 2 number. Connect and share knowledge within a single location that is structured and easy to search. Iterate through the list of dbs to get all tables in respective database(s), If all files are in HDFS you can get the size. Each room features air conditioning, an extra-long, twin-size bed, a desk, a chair, a wardrobe with drawers . So what does that mean? i got the output. in OLAP and OLTP environment along with DB role . hive.auto.convert.join, Hive generates three or more map-side joins with an assumption that all tables are of smaller size. Do roots of these polynomials approach the negative of the Euler-Mascheroni constant? Relax, unwind and create the perfect space with the Domi round coffee table, richly crafted from sustainable Mango wood and Rattan. [jira] [Updated] (HIVE-19334) Use actual file size rather than stats for fetch task optimization with external tables. numPartitions: Full text of the 'Sri Mahalakshmi Dhyanam & Stotram', Relation between transaction data and transaction id. // Order may vary, as spark processes the partitions in parallel. Use parquet format to store data of your external/internal table. 01-13-2017 This four-story residence hall provides coeducational housing for approximately 250 students. Procedure Log in to FusionInsight Manager. [jira] [Updated] (HIVE-19334) Use actual file size rather than stats for fetch task optimization with external tables. path is like /FileStore/tables/your folder name/your file; Refer to the image below for example. The files are appended in the directory. If so, how? I recall something like that. Answer. Is there a way to check the size of Hive tables in one shot? spark-warehouse in the current directory that the Spark application is started. this return nothing in hive. 01-17-2017 SELECT SUM (PARAM_VALUE) FROM TABLE_PARAMS WHERE PARAM_KEY="totalSize"; Get the table ID of the Hive table forms the TBLS table and run the following query: SELECT TBL_ID FROM TBLS WHERE TBL_NAME='test'; SELECT * FROM TABLE_PARAMS WHERE TBL_ID=5109; But when there are many databases or tables (especially external tables) with data present in multiple different directories in HDFS, the below might help in determining the size. Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. For text-based files, use the keywords STORED as TEXTFILE. hive> select length (col1) from bigsql.test_table; OK 6 Cause This is expected behavior. Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. Hive explain Table Parameters: totalSize doesn't m Open Sourcing Clouderas ML Runtimes - why it matters to customers? Can we check size of Hive tables? the hive.metastore.warehouse.dir property in hive-site.xml is deprecated since Spark 2.0.0. 8 How do I tell hive about file formats in HDFS? When you run DROP TABLE on an external table, by default Hive drops only the metadata (schema). # Queries can then join DataFrame data with data stored in Hive. 99.4 is replica of the data right, hdfs dfs -du -s -h /data/warehouse/test.db/test33.1 G 99.4 G /data/warehouse/test.db/test, Created - edited and its dependencies, including the correct version of Hadoop. The company is the world's leading enterprise resource planning (ERP) software vendor. How to limit parquet file dimension for a parquet table in hive? But it is useful for one table. Hive supports tables up to 300PB in Optimized Row Columnar (ORC) format. How do you write a good story in Smash Bros screening? After 3 replicas it is 99.4GB. 324 and 972 are the sizes of one and three replicas of the table data in HDFS. Database name: Created on "output format". Prerequisites The Hive and HDFS components are running properly. If so, how? the serde. Starting from Spark 1.4.0, a single binary What happens when a managed table is dropped in hive? For updating data, you can use the MERGE statement, which now also meets ACID standards. To learn more, see our tips on writing great answers. Managed or external tables can be identified using the DESCRIBE FORMATTED table_name command, which will display either MANAGED_TABLE or EXTERNAL_TABLE depending on table type. Staging Ground Beta 1 Recap, and Reviewers needed for Beta 2. it is tedious to run the same command for each table. 2. HIVE-19334.4.patch > Use actual file size rather than stats for fetch task optimization with > external tables . Since this is an external table ( EXTERNAL_TABLE), Hive will not keep any stats on the table since it is assumed that another application is changing the underlying data at will. To gather statistic numRows / rawDataSize for Parquet and ORC format, Flink will only read the file's footer to do fast gathering. # Key: 0, Value: val_0 Not the answer you're looking for? Resolving The Problem To compare accurately: 01-16-2017 Hive: how to show all partitions of a table? in terms of the TB's, etc. The size of real data files is matched11998371425. repopulate so size is different but still not match11998371425. hdfs dfs -du -s -h /data/warehouse/test.db/test/22.5 G 67.4 G /data/warehouse/test.db/test. Jason Dere (JIRA) . These options can only be used with "textfile" fileFormat. For example:, if partition by date (mm-dd-yyyy). Jason Dere (JIRA) [jira] [Updated] (HIVE-19334) Use actual file size . Managed Table/Internal Table. We also use third-party cookies that help us analyze and understand how you use this website. Created on Is a PhD visitor considered as a visiting scholar? For a managed (non-external) table, data is manipulated through Hive SQL statements (LOAD DATA, INSERT, etc.) . To get the size of your test table (replace database_name and table_name by real values) just use something like (check the value of hive.metastore.warehouse.dir for /apps/hive/warehouse): [ hdfs @ server01 ~] $ hdfs dfs -du -s -h / apps / hive / warehouse / database_name / table_name If the PURGE option is not specified, the data is moved to a trash folder for a defined duration. tblproperties will give the size of the table and can be used to grab just that value if needed. // Queries can then join DataFrame data with data stored in Hive. The data will be store on the distributed manager. Why do small African island nations perform better than African continental nations, considering democracy and human development? By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. The LENGTH function in Big SQL counts bytes, whereas LENGTH function in Hive counts characters. If Hive dependencies can be found on the classpath, Spark will load them Partition logdata.ops_bc_log{day=20140523} stats: [numFiles=37, Partitioning Tables: Hive partitioning is an effective method to improve the query performance on larger tables. # | 2| val_2| 2| val_2| property can be one of four options: Comma-separated paths of the jars that used to instantiate the HiveMetastoreClient. # +--------+ the same version as. This classpath must include all of Hive The total size of the Hive Database can be fetched using Hive Metastore DB in the TABLE_PARAMS table. See other answer below. Why are ripples in water always circular? However I ran the hdfs command and got two sizes back. How to notate a grace note at the start of a bar with lilypond? How do I tell hive about file formats in HDFS? Is it possible to create a concave light? These configs provide deep control over lower level aspects like file sizing, compression, parallelism, compaction, write schema, cleaning etc. There is an alternative way(can't say alternate but better latency than above case) : and run the same command ( select count(*) from tbl ) which gives better latency than prior. The cookies is used to store the user consent for the cookies in the category "Necessary". # Key: 0, Value: val_0 Hive is an ETL and Data warehousing tool developed on top of Hadoop Distributed File System (HDFS). You can use the hdfs dfs -du /path/to/table command or hdfs dfs -count -q -v -h /path/to/table to get the size of an HDFS path (or table). I have many tables in Hive and suspect size of these tables are causing space issues on HDFS FS. Connect and share knowledge within a single location that is structured and easy to search. This cookie is set by GDPR Cookie Consent plugin. Hive supports ANSI SQL and atomic, consistent, isolated, and durable (ACID) transactions. [This can be checked in the table TABLE_PARAMS in Metastore DB that I have also mentioned below (How it works?.b)]. adds support for finding tables in the MetaStore and writing queries using HiveQL. Then you will get quicker results. 05:38 PM, Created I have many tables in Hive and suspect size of these tables are causing space issues on cluster. Each suite features two double-occupancy rooms with private bathroom facilities, community cabinets with a sink, a living room with a couch, end tables, a coffee table, and entertainment stand. Jason Dere (JIRA) Reply via email to Search the site. Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features. Note that Next, verify the database is created by running the show command: show databases; 3. What is Hive Temporary Tables? Big tables can cause the performance issue in the Hive.Below are some of methods that you can use to list Hive high volume tables. If the location is not specified, by default all metadata gets stored in this path. CREATE TABLE src(id int) USING hive OPTIONS(fileFormat 'parquet'). What is the point of Thrower's Bandolier? 02:07 PM. 07-09-2018 vegan) just to try it, does this inconvenience the caterers and staff? This cookie is set by GDPR Cookie Consent plugin. These materialized views use the default file format configured in the optional hive.storage-format catalog configuration property, which defaults to ORC. Tables created by oozie hive action cannot be found from hive client but can find them in HDFS. # # You can also use DataFrames to create temporary views within a SparkSession. In the hive, the tables are consisting of columns and rows and store the related data in the table format within the same database. In the hive, the actual data will be store on the HDFS level. Steps to Read Hive Table into PySpark DataFrame Step 1 - Import PySpark Step 2 - Create SparkSession with Hive enabled Step 3 - Read Hive table into Spark DataFrame using spark.sql () Step 4 - Read using spark.read.table () Step 5 - Connect to remove Hive. Uses high CPU resources to compress and decompress data. Staging Ground Beta 1 Recap, and Reviewers needed for Beta 2, Hive "ANALYZE TABLE" how to execute from java. Find centralized, trusted content and collaborate around the technologies you use most. The query takes the sum of total size of all the Hive tables based on the statistics of the tables. The table is storing the records or data in tabular format. 99.4 is replica of the data, Created Kate believes the key to living well, and healthy, is to plug into what your body needs, understanding that one size does not fit all, all the time, and being truly honest with yourself about your goals and desires. // The items in DataFrames are of type Row, which allows you to access each column by ordinal. it is tedious to run the same command for each table. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. rawDataSize: Follow the steps below to create a table in Hive. Why keep stats if we cant trust that the data will be the same in another 5 minutes? 01-17-2017 of Hive that Spark SQL is communicating with. 12-06-2017 Why keep stats if we can't trust that the data will be the same in another 5 minutes? creates a directory configured by spark.sql.warehouse.dir, which defaults to the directory 03:54 AM. Users who do not have an existing Hive deployment can still enable Hive support. Location of the jars that should be used to instantiate the HiveMetastoreClient. Is there a way to check the size of Hive tables in one shot? -rwxrwx--x+ 3 hive hive 367910722 2018-07-02 19:31 /data/warehouse/test.db/test/000000_0-rwxrwx--x+ 3 hive hive 367471711 2018-07-02 19:31 /data/warehouse/test.db/test/000001_0-rwxrwx--x+ 3 hive hive 367046633 2018-07-02 19:31 /data/warehouse/test.db/test/000002_0-rwxrwx--x+ 3 hive hive 316203889 2018-07-02 19:30 /data/warehouse/test.db/test/000003_0-rwxrwx--x+ 3 hive hive 316181782 2018-07-02 19:30 /data/warehouse/test.db/test/000004_0-rwxrwx--x+ 3 hive hive 315975500 2018-07-02 19:30 /data/warehouse/test.db/test/000005_0-rwxrwx--x+ 3 hive hive 315922390 2018-07-02 19:30 /data/warehouse/test.db/test/000006_0-rwxrwx--x+ 3 hive hive 315912232 2018-07-02 19:30 /data/warehouse/test.db/test/000007_0-rwxrwx--x+ 3 hive hive 315885689 2018-07-02 19:30 /data/warehouse/test.db/test/000008_0-rwxrwx--x+ 3 hive hive 315619051 2018-07-02 19:30 /data/warehouse/test.db/test/000009_0-rwxrwx--x+ 3 hive hive 289731869 2018-07-02 19:30 /data/warehouse/test.db/test/000010_0-rwxrwx--x+ 3 hive hive 261527233 2018-07-02 19:30 /data/warehouse/test.db/test/000011_0-rwxrwx--x+ 3 hive hive 261535458 2018-07-02 19:30 /data/warehouse/test.db/test/000012_0-rwxrwx--x+ 3 hive hive 261509341 2018-07-02 19:30 /data/warehouse/test.db/test/000013_0-rwxrwx--x+ 3 hive hive 261542760 2018-07-02 19:30 /data/warehouse/test.db/test/000014_0-rwxrwx--x+ 3 hive hive 261584890 2018-07-02 19:30 /data/warehouse/test.db/test/000015_0-rwxrwx--x+ 3 hive hive 261550533 2018-07-02 19:30 /data/warehouse/test.db/test/000016_0-rwxrwx--x+ 3 hive hive 261539025 2018-07-02 19:30 /data/warehouse/test.db/test/000017_0-rwxrwx--x+ 3 hive hive 261516408 2018-07-02 19:30 /data/warehouse/test.db/test/000018_0-rwxrwx--x+ 3 hive hive 261904082 2018-07-02 19:30 /data/warehouse/test.db/test/000019_0-rwxrwx--x+ 3 hive hive 261522663 2018-07-02 19:30 /data/warehouse/test.db/test/000020_0-rwxrwx--x+ 3 hive hive 261570466 2018-07-02 19:30 /data/warehouse/test.db/test/000021_0-rwxrwx--x+ 3 hive hive 261536035 2018-07-02 19:30 /data/warehouse/test.db/test/000022_0-rwxrwx--x+ 3 hive hive 261490152 2018-07-02 19:30 /data/warehouse/test.db/test/000023_0-rwxrwx--x+ 3 hive hive 261512588 2018-07-02 19:30 /data/warehouse/test.db/test/000024_0-rwxrwx--x+ 3 hive hive 261515184 2018-07-02 19:30 /data/warehouse/test.db/test/000025_0-rwxrwx--x+ 3 hive hive 261515829 2018-07-02 19:30 /data/warehouse/test.db/test/000026_0-rwxrwx--x+ 3 hive hive 261545935 2018-07-02 19:30 /data/warehouse/test.db/test/000027_0-rwxrwx--x+ 3 hive hive 261568153 2018-07-02 19:30 /data/warehouse/test.db/test/000028_0-rwxrwx--x+ 3 hive hive 261881698 2018-07-02 19:30 /data/warehouse/test.db/test/000029_0-rwxrwx--x+ 3 hive hive 233055511 2018-07-02 19:30 /data/warehouse/test.db/test/000030_0-rwxrwx--x+ 3 hive hive 233060147 2018-07-02 19:30 /data/warehouse/test.db/test/000031_0-rwxrwx--x+ 3 hive hive 232552454 2018-07-02 19:30 /data/warehouse/test.db/test/000032_0-rwxrwx--x+ 3 hive hive 181403967 2018-07-02 19:30 /data/warehouse/test.db/test/000033_0-rwxrwx--x+ 3 hive hive 181423669 2018-07-02 19:30 /data/warehouse/test.db/test/000034_0-rwxrwx--x+ 3 hive hive 181260203 2018-07-02 19:30 /data/warehouse/test.db/test/000035_0-rwxrwx--x+ 3 hive hive 181226055 2018-07-02 19:30 /data/warehouse/test.db/test/000036_0-rwxrwx--x+ 3 hive hive 181211848 2018-07-02 19:30 /data/warehouse/test.db/test/000037_0-rwxrwx--x+ 3 hive hive 127307473 2018-07-02 19:29 /data/warehouse/test.db/test/000038_0-rwxrwx--x+ 3 hive hive 127324022 2018-07-02 19:29 /data/warehouse/test.db/test/000039_0-rwxrwx--x+ 3 hive hive 98865763 2018-07-02 19:29 /data/warehouse/test.db/test/000040_0-rwxrwx--x+ 3 hive hive 98650885 2018-07-02 19:29 /data/warehouse/test.db/test/000041_0-rwxrwx--x+ 3 hive hive 240568542 2018-07-02 19:29 /data/warehouse/test.db/test/000042_0-rwxrwx--x+ 3 hive hive 240384660 2018-07-02 19:29 /data/warehouse/test.db/test/000043_0-rwxrwx--x+ 3 hive hive 47556388 2018-07-02 19:29 /data/warehouse/test.db/test/000044_0-rwxrwx--x+ 3 hive hive 47553467 2018-07-02 19:29 /data/warehouse/test.db/test/000045_0-rwxrwx--x+ 3 hive hive 47214429 2018-07-02 19:29 /data/warehouse/test.db/test/000046_0-rwxrwx--x+ 3 hive hive 47008567 2018-07-02 19:29 /data/warehouse/test.db/test/000047_0-rwxrwx--x+ 3 hive hive 116398133 2018-07-02 19:29 /data/warehouse/test.db/test/000048_0-rwxrwx--x+ 3 hive hive 116264278 2018-07-02 19:29 /data/warehouse/test.db/test/000049_0-rwxrwx--x+ 3 hive hive 116108618 2018-07-02 19:29 /data/warehouse/test.db/test/000050_0-rwxrwx--x+ 3 hive hive 116102337 2018-07-02 19:29 /data/warehouse/test.db/test/000051_0-rwxrwx--x+ 3 hive hive 116197882 2018-07-02 19:29 /data/warehouse/test.db/test/000052_0-rwxrwx--x+ 3 hive hive 115942226 2018-07-02 19:29 /data/warehouse/test.db/test/000053_0drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_stagingdrwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000000_2105670738_dir-rwxrwx--x+ 3 hive hive 198160 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000000_2105670738_dir/c6473ef4a4aff1c5-97654d1e00000000_372249781_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000001_539358072_dir-rwxrwx--x+ 3 hive hive 191858 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000001_539358072_dir/c6473ef4a4aff1c5-97654d1e00000001_497911501_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000003_201543806_dir-rwxrwx--x+ 3 hive hive 198255 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000003_201543806_dir/c6473ef4a4aff1c5-97654d1e00000003_1954232146_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000004_430812106_dir-rwxrwx--x+ 3 hive hive 196661 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000004_430812106_dir/c6473ef4a4aff1c5-97654d1e00000004_1303838926_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000006_1445626883_dir-rwxrwx--x+ 3 hive hive 198692 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000006_1445626883_dir/c6473ef4a4aff1c5-97654d1e00000006_427021246_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000007_2105670738_dir-rwxrwx--x+ 3 hive hive 189234 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000007_2105670738_dir/c6473ef4a4aff1c5-97654d1e00000007_372249781_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000008_1712792446_dir-rwxrwx--x+ 3 hive hive 191664 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000008_1712792446_dir/c6473ef4a4aff1c5-97654d1e00000008_2033565865_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000009_889847462_dir-rwxrwx--x+ 3 hive hive 191028 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000009_889847462_dir/c6473ef4a4aff1c5-97654d1e00000009_455426067_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000000a_2105670738_dir-rwxrwx--x+ 3 hive hive 191804 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000000a_2105670738_dir/c6473ef4a4aff1c5-97654d1e0000000a_372249781_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000000b_1200230056_dir-rwxrwx--x+ 3 hive hive 188807 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000000b_1200230056_dir/c6473ef4a4aff1c5-97654d1e0000000b_154797175_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000000c_41928458_dir-rwxrwx--x+ 3 hive hive 190041 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000000c_41928458_dir/c6473ef4a4aff1c5-97654d1e0000000c_2105670738_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000000e_430812106_dir-rwxrwx--x+ 3 hive hive 190247 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000000e_430812106_dir/c6473ef4a4aff1c5-97654d1e0000000e_1303838926_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000000f_818141150_dir-rwxrwx--x+ 3 hive hive 189097 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000000f_818141150_dir/c6473ef4a4aff1c5-97654d1e0000000f_430812106_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000010_430812106_dir-rwxrwx--x+ 3 hive hive 189674 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000010_430812106_dir/c6473ef4a4aff1c5-97654d1e00000010_1303838926_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000011_430812106_dir-rwxrwx--x+ 3 hive hive 188682 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000011_430812106_dir/c6473ef4a4aff1c5-97654d1e00000011_1303838926_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000012_504389356_dir-rwxrwx--x+ 3 hive hive 199549 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000012_504389356_dir/c6473ef4a4aff1c5-97654d1e00000012_35243077_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000013_204459993_dir-rwxrwx--x+ 3 hive hive 189081 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000013_204459993_dir/c6473ef4a4aff1c5-97654d1e00000013_289499470_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000014_818141150_dir-rwxrwx--x+ 3 hive hive 189618 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000014_818141150_dir/c6473ef4a4aff1c5-97654d1e00000014_430812106_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000015_818141150_dir-rwxrwx--x+ 3 hive hive 187391 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000015_818141150_dir/c6473ef4a4aff1c5-97654d1e00000015_430812106_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000016_1470504203_dir-rwxrwx--x+ 3 hive hive 188783 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000016_1470504203_dir/c6473ef4a4aff1c5-97654d1e00000016_818141150_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000017_1908337438_dir-rwxrwx--x+ 3 hive hive 190917 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000017_1908337438_dir/c6473ef4a4aff1c5-97654d1e00000017_1642311642_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000018_89561857_dir-rwxrwx--x+ 3 hive hive 191811 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000018_89561857_dir/c6473ef4a4aff1c5-97654d1e00000018_504389356_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000019_89561857_dir-rwxrwx--x+ 3 hive hive 199804 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000019_89561857_dir/c6473ef4a4aff1c5-97654d1e00000019_504389356_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000001a_430812106_dir-rwxrwx--x+ 3 hive hive 189869 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000001a_430812106_dir/c6473ef4a4aff1c5-97654d1e0000001a_1303838926_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000001b_89561857_dir-rwxrwx--x+ 3 hive hive 189359 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000001b_89561857_dir/c6473ef4a4aff1c5-97654d1e0000001b_504389356_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000001c_1594731110_dir-rwxrwx--x+ 3 hive hive 190337 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000001c_1594731110_dir/c6473ef4a4aff1c5-97654d1e0000001c_909335710_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000001d_909335710_dir-rwxrwx--x+ 3 hive hive 198520 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000001d_909335710_dir/c6473ef4a4aff1c5-97654d1e0000001d_89561857_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000001f_204459993_dir-rwxrwx--x+ 3 hive hive 189651 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000001f_204459993_dir/c6473ef4a4aff1c5-97654d1e0000001f_289499470_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000020_204459993_dir-rwxrwx--x+ 3 hive hive 190786 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000020_204459993_dir/c6473ef4a4aff1c5-97654d1e00000020_289499470_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000021_1303838926_dir-rwxrwx--x+ 3 hive hive 187068 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000021_1303838926_dir/c6473ef4a4aff1c5-97654d1e00000021_889847462_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000023_1592629146_dir-rwxrwx--x+ 3 hive hive 191021 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000023_1592629146_dir/c6473ef4a4aff1c5-97654d1e00000023_1508635095_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000024_909335710_dir-rwxrwx--x+ 3 hive hive 189046 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000024_909335710_dir/c6473ef4a4aff1c5-97654d1e00000024_89561857_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000025_1594731110_dir-rwxrwx--x+ 3 hive hive 198569 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000025_1594731110_dir/c6473ef4a4aff1c5-97654d1e00000025_909335710_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000026_1594731110_dir-rwxrwx--x+ 3 hive hive 190048 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000026_1594731110_dir/c6473ef4a4aff1c5-97654d1e00000026_909335710_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000028_1071593251_dir-rwxrwx--x+ 3 hive hive 189253 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000028_1071593251_dir/c6473ef4a4aff1c5-97654d1e00000028_656030523_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000029_289499470_dir-rwxrwx--x+ 3 hive hive 198856 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e00000029_289499470_dir/c6473ef4a4aff1c5-97654d1e00000029_2082616914_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000002b_89561857_dir-rwxrwx--x+ 3 hive hive 190164 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/c6473ef4a4aff1c5_97654d1e00000000/.c6473ef4a4aff1c5-97654d1e0000002b_89561857_dir/c6473ef4a4aff1c5-97654d1e0000002b_504389356_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000000_103358247_dir-rwxrwx--x+ 3 hive hive 189672 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000000_103358247_dir/ee49ddc9ea1e6ab3-db0ad5100000000_64130302_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000001_103358247_dir-rwxrwx--x+ 3 hive hive 198081 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000001_103358247_dir/ee49ddc9ea1e6ab3-db0ad5100000001_64130302_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000002_1775557661_dir-rwxrwx--x+ 3 hive hive 198713 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000002_1775557661_dir/ee49ddc9ea1e6ab3-db0ad5100000002_208644362_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000003_366965898_dir-rwxrwx--x+ 3 hive hive 198255 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000003_366965898_dir/ee49ddc9ea1e6ab3-db0ad5100000003_1095655744_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000004_1658557076_dir-rwxrwx--x+ 3 hive hive 196661 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000004_1658557076_dir/ee49ddc9ea1e6ab3-db0ad5100000004_2080684887_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000005_2080684887_dir-rwxrwx--x+ 3 hive hive 189399 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000005_2080684887_dir/ee49ddc9ea1e6ab3-db0ad5100000005_2132751012_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000006_299885815_dir-rwxrwx--x+ 3 hive hive 198692 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000006_299885815_dir/ee49ddc9ea1e6ab3-db0ad5100000006_2138387494_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000007_103358247_dir-rwxrwx--x+ 3 hive hive 189856 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000007_103358247_dir/ee49ddc9ea1e6ab3-db0ad5100000007_64130302_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000008_208644362_dir-rwxrwx--x+ 3 hive hive 191664 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000008_208644362_dir/ee49ddc9ea1e6ab3-db0ad5100000008_749395383_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000009_1742846925_dir-rwxrwx--x+ 3 hive hive 191028 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000009_1742846925_dir/ee49ddc9ea1e6ab3-db0ad5100000009_249944867_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000000a_1658557076_dir-rwxrwx--x+ 3 hive hive 191804 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000000a_1658557076_dir/ee49ddc9ea1e6ab3-db0ad510000000a_2080684887_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000000b_1232039013_dir-rwxrwx--x+ 3 hive hive 188339 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000000b_1232039013_dir/ee49ddc9ea1e6ab3-db0ad510000000b_1724061052_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000000c_2110769147_dir-rwxrwx--x+ 3 hive hive 190041 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000000c_2110769147_dir/ee49ddc9ea1e6ab3-db0ad510000000c_1658557076_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000000d_2080684887_dir-rwxrwx--x+ 3 hive hive 190027 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000000d_2080684887_dir/ee49ddc9ea1e6ab3-db0ad510000000d_2132751012_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000000e_459194874_dir-rwxrwx--x+ 3 hive hive 198859 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000000e_459194874_dir/ee49ddc9ea1e6ab3-db0ad510000000e_1794854069_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000000f_1509661478_dir-rwxrwx--x+ 3 hive hive 189097 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000000f_1509661478_dir/ee49ddc9ea1e6ab3-db0ad510000000f_459194874_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000010_459194874_dir-rwxrwx--x+ 3 hive hive 189674 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000010_459194874_dir/ee49ddc9ea1e6ab3-db0ad5100000010_1794854069_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000011_459194874_dir-rwxrwx--x+ 3 hive hive 191388 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000011_459194874_dir/ee49ddc9ea1e6ab3-db0ad5100000011_1794854069_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000012_2055542707_dir-rwxrwx--x+ 3 hive hive 192191 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000012_2055542707_dir/ee49ddc9ea1e6ab3-db0ad5100000012_486520041_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000013_1981261782_dir-rwxrwx--x+ 3 hive hive 189091 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000013_1981261782_dir/ee49ddc9ea1e6ab3-db0ad5100000013_1397523618_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000014_1224861606_dir-rwxrwx--x+ 3 hive hive 189618 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000014_1224861606_dir/ee49ddc9ea1e6ab3-db0ad5100000014_2015483939_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000015_1509661478_dir-rwxrwx--x+ 3 hive hive 187391 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000015_1509661478_dir/ee49ddc9ea1e6ab3-db0ad5100000015_459194874_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000016_1240087244_dir-rwxrwx--x+ 3 hive hive 188783 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000016_1240087244_dir/ee49ddc9ea1e6ab3-db0ad5100000016_1509661478_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000017_1348280926_dir-rwxrwx--x+ 3 hive hive 190917 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000017_1348280926_dir/ee49ddc9ea1e6ab3-db0ad5100000017_1999868437_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000019_1501051347_dir-rwxrwx--x+ 3 hive hive 190498 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000019_1501051347_dir/ee49ddc9ea1e6ab3-db0ad5100000019_1653124156_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000001a_1397523618_dir-rwxrwx--x+ 3 hive hive 189869 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000001a_1397523618_dir/ee49ddc9ea1e6ab3-db0ad510000001a_1501051347_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000001b_292368280_dir-rwxrwx--x+ 3 hive hive 189359 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000001b_292368280_dir/ee49ddc9ea1e6ab3-db0ad510000001b_196274898_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000001c_1379540145_dir-rwxrwx--x+ 3 hive hive 189653 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000001c_1379540145_dir/ee49ddc9ea1e6ab3-db0ad510000001c_195689393_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000001d_802814478_dir-rwxrwx--x+ 3 hive hive 189700 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000001d_802814478_dir/ee49ddc9ea1e6ab3-db0ad510000001d_292368280_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000001e_196274898_dir-rwxrwx--x+ 3 hive hive 198079 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000001e_196274898_dir/ee49ddc9ea1e6ab3-db0ad510000001e_1775035924_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000001f_1379540145_dir-rwxrwx--x+ 3 hive hive 192717 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000001f_1379540145_dir/ee49ddc9ea1e6ab3-db0ad510000001f_195689393_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000020_1686465697_dir-rwxrwx--x+ 3 hive hive 190786 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000020_1686465697_dir/ee49ddc9ea1e6ab3-db0ad5100000020_802814478_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000021_1501051347_dir-rwxrwx--x+ 3 hive hive 191368 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000021_1501051347_dir/ee49ddc9ea1e6ab3-db0ad5100000021_1653124156_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000023_1672430085_dir-rwxrwx--x+ 3 hive hive 191021 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000023_1672430085_dir/ee49ddc9ea1e6ab3-db0ad5100000023_827383921_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000024_195689393_dir-rwxrwx--x+ 3 hive hive 190190 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000024_195689393_dir/ee49ddc9ea1e6ab3-db0ad5100000024_145298882_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000025_1071593251_dir-rwxrwx--x+ 3 hive hive 198569 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000025_1071593251_dir/ee49ddc9ea1e6ab3-db0ad5100000025_656030523_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000026_1379540145_dir-rwxrwx--x+ 3 hive hive 190048 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000026_1379540145_dir/ee49ddc9ea1e6ab3-db0ad5100000026_195689393_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000027_656030523_dir-rwxrwx--x+ 3 hive hive 189612 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000027_656030523_dir/ee49ddc9ea1e6ab3-db0ad5100000027_2139712501_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000028_372249549_dir-rwxrwx--x+ 3 hive hive 189253 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000028_372249549_dir/ee49ddc9ea1e6ab3-db0ad5100000028_89180712_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000029_656030523_dir-rwxrwx--x+ 3 hive hive 191232 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad5100000029_656030523_dir/ee49ddc9ea1e6ab3-db0ad5100000029_2139712501_data.0.drwxrwx--x+ - hive hive 0 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000002b_145298882_dir-rwxrwx--x+ 3 hive hive 189856 2018-05-04 18:56 /data/warehouse/test.db/test/_impala_insert_staging/ee49ddc9ea1e6ab3_db0ad5100000000/.ee49ddc9ea1e6ab3-db0ad510000002b_145298882_dir/ee49ddc9ea1e6ab3-db0ad510000002b_1950458973_data.0.