hive table size

Step 1: Start all your Hadoop Daemon start-dfs.sh # this will start namenode, datanode and secondary namenode start-yarn.sh # this will start node manager and resource manager jps # To check running daemons Step 2: Launch hive from terminal hive Creating Table in Hive // Partitioned column `key` will be moved to the end of the schema. Created on The company is the world's leading enterprise resource planning (ERP) software vendor. Once done, you can execute the below query to get the total size of all the tables in Hive in. Below are the steps to launch a hive on your local system. A service that provides metastore access to other Apache Hive services. Staging Ground Beta 1 Recap, and Reviewers needed for Beta 2, Hive "ANALYZE TABLE" how to execute from java. Is there a Hive query to quickly find table size (i.e. If you want the DROP TABLE command to also remove the actual data in the external table, as DROP TABLE does on a managed table, you need to configure the table properties accordingly. However I ran the hdfs command and got two sizes back. Answer The HDFS refined monitoring function allows you to monitor the size of a specified table directory. 07-11-2018 By default, we will read the table files as plain text. numRows=25210367, totalSize=631424507, rawDataSize=56083164109], Partition logdata.ops_bc_log{day=20140522} stats: [numFiles=37, Switch to the HBase schema and issue the SHOW TABLES command to see the HBase tables that exist within the schema. I was wondering if there is a way to enforce compression on table itself so that even if the above two properties are not set the data is always compressed? 01-16-2017 05:38 PM, Created Free Shipping HIVE TO TABLE HONEY ORGANIC NON GMO Advertising Vinyl Banner Flag Sign Many Size World-renowned fashion, Official Site., tens of thousands of products for your choice. It is a good question. Recovering from a blunder I made while emailing a professor, How to handle a hobby that makes income in US. To list the sizes of Hive tables in Hadoop in GBs: 1 1 sudo -u hdfs hadoop fs -du /user/hive/warehouse/ | awk '/^ [0-9]+/ { print int ($1/ (1024**3)) " [GB]\t" $2 }' Result: 1 448 [GB]. How can check Hive table size? 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. 2. Jason Dere (JIRA) [jira] [Updated] (HIVE-19334) Use actual file size . # | 2| val_2| 2| val_2| Afrikaans; ; Azrbaycanca; ; ; Bosanski; Catal; etina; Cymraeg; Dansk; Deutsch; Eesti; . For example:, if partition by date (mm-dd-yyyy). This classpath must include all of Hive The provided jars should be 07-05-2018 access data stored in Hive. Otherwise, only numFiles / totalSize can be gathered. Can we check size of Hive tables? 1) SELECT key, size FROM table; 4923069104295859283. Whether you are creating a coastal inspired or boho home, this table will suit any space - perfect for alfresco living. Hive stores query logs on a per Hive session basis in /tmp/<user.name>/ by default. Jason Dere (JIRA) . How Intuit democratizes AI development across teams through reusability. shared between Spark SQL and a specific version of Hive. However, since Hive has a large number of dependencies, these dependencies are not included in the 02:07 PM. I am looking for a approach to run a command and get all required info. # +---+------+---+------+ But it is useful for one table. For a managed (non-external) table, data is manipulated through Hive SQL statements (LOAD DATA, INSERT, etc.) // You can also use DataFrames to create temporary views within a SparkSession. An example of classes that should What does hdfs dfs -du -s -h /path/to/table output? Reply 9,098 Views 0 Kudos ranan Contributor Created 07-06-2018 09:28 AM Thank you for your reply Eric Du return 2 number. . Users who do not have an existing Hive deployment can still enable Hive support. // The items in DataFrames are of type Row, which allows you to access each column by ordinal. # Queries can then join DataFrame data with data stored in Hive. You also need to define how this table should deserialize the data to rows, or serialize rows to data, i.e. Version of the Hive metastore. You can either select the Azure SQL Database for the external Hive metastore from Azure subscription list, or enter the . 01-13-2017 By default the replica is 3. The Mail Archive home; issues - all . To subscribe to this RSS feed, copy and paste this URL into your RSS reader. totalSize: The output should be including below fields: i got the output. 01-17-2017 If the PURGE option is not specified, the data is moved to a trash folder for a defined duration. Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors. the same version as. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. # PySpark Usage Guide for Pandas with Apache Arrow, Specifying storage format for Hive tables, Interacting with Different Versions of Hive Metastore. Browse other questions tagged, Where developers & technologists share private knowledge with coworkers, Reach developers & technologists worldwide. The files are appended in the directory. When not configured But opting out of some of these cookies may affect your browsing experience. 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. It does not store any personal data. 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. % scala spark.read.table ("< non-delta-table-name >") .queryExecution.analyzed.stats Was this article helpful? // Queries can then join DataFrames data with data stored in Hive. Hive: how to show all partitions of a table? It will able to handle a huge amount of data i.e. Create a database named "company" by running the create command: create database company; The terminal prints a confirmation message and the time needed to perform the action. 01-17-2017 A fileFormat is kind of a package of storage format specifications, including "serde", "input format" and - the incident has nothing to do with me; can I use this this way? c. hdfs du -s output of the same table from HDFS. table_name [ (col_name data_type [COMMENT col_comment], .)] the output looke like this: hdfs dfs -du -s -h hdfs://hdpprd/data/prod/users/ip2738/ldl_cohort_with_tests, result:2.9 G 8.8 G hdfs://hdpprd/data/prod/users/ip2738/ldl_cohort_with_tests, Created Materialized views optimize queries based on access patterns. These cookies ensure basic functionalities and security features of the website, anonymously. # The results of SQL queries are themselves DataFrames and support all normal functions. By clicking Accept All, you consent to the use of ALL the cookies. Hive simplifies the performance of operations such as: Data encapsulation Ad-hoc queries Analysis of huge datasets But what makes Hive standout? 01-09-2018 Mutually exclusive execution using std::atomic? One of the most important pieces of Spark SQLs Hive support is interaction with Hive metastore, //aewb-analytics-staging-name.example.com:8020/user/hive/warehouse/mybigtable, //aewb-analytics-staging-name.example.com:8020/user/hive/warehouse/anotherone, //aewb-analytics-staging-name.example.com:8020/user/hive/warehouse/tinyone, https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Describe. Step 2: Create a DataFrame Is there a way to check the size of Hive tables? 2) select * from table; IDcf07c309-c685-4bf4-9705-8bca69b00b3c HIVE_BAD_DATA: Field size's type LONG in ORC is incompatible with type varchar defined in table schema Can I tell police to wait and call a lawyer when served with a search warrant? <br> In-depth knowledge in Database Objects creation such as Tables, Table partitioning, Indexes, Stored Procedures, Views, User Defined Functions, Cursors & Triggers etc. The tables are broadly classified into two parts i.e. to rows, or serialize rows to data, i.e. These cookies track visitors across websites and collect information to provide customized ads. The next point which is the hdfs du -s can be compared to check this. "After the incident", I started to be more careful not to trip over things. 06:25 AM, When i run du command it give me below size of table, 33.1 GB hdfs dfs -du -s -h /data/warehouse/test.db/test, ANALYZE TABLECOMPUTE STATISTICS FOR COLUMNS, Created Why do small African island nations perform better than African continental nations, considering democracy and human development? When you run DROP TABLE on an external table, by default Hive drops only the metadata (schema). If so, how close was it? By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. 03:54 AM. options are. On a single core of a Core i7 processor in 64-bit mode, it compresses at about 250 MB/sec or more and decompresses at about 500 MB/sec or more. The four most widely used Compression formats in Hadoop are as follows: The principle being that file sizes will be larger when compared with gzip or bzip2. numRows=26295075, totalSize=657113440, rawDataSize=58496087068], solution, though not quick 3. # +---+-------+ Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. 03:45 AM, Created 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. creates a directory configured by spark.sql.warehouse.dir, which defaults to the directory # +--------+ Is there a way to check the size of Hive tables in one shot? Hive temporary tables are similar to temporary tables that exist in SQL Server or any RDBMS databases, As the name suggests these tables are created temporarily within an active session. All other properties defined with OPTIONS will be regarded as Hive serde properties. @DanielLangdon are the units of rawDataSize bytes, blocks or something else? the "serde". This can vastly improve query times on the table because it collects the row count, file count, and file size (bytes) that make up the data in the table and gives that to the query planner before execution. By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. When working with Hive, one must instantiate SparkSession with Hive support, including -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.

hive table size 2023