Chris Rutherford Boomtown,
Was Sister Monica Joan A Real Person,
What Time Can You Cash In Scratchers,
$20,000 Grant Illinois,
Articles H
By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. What happened when a managed table is dropped? hive> show tables;OKbee_actionsbee_billsbee_chargesbee_cpc_notifsbee_customersbee_interactionsbee_master_03jun2016_to_17oct2016bee_master_18may2016_to_02jun2016bee_master_18oct2016_to_21dec2016bee_master_20160614_021501bee_master_20160615_010001bee_master_20160616_010001bee_master_20160617_010001bee_master_20160618_010001bee_master_20160619_010001bee_master_20160620_010001bee_master_20160621_010002bee_master_20160622_010001bee_master_20160623_010001bee_master_20160624_065545bee_master_20160625_010001bee_master_20160626_010001bee_master_20160627_010001bee_master_20160628_010001bee_master_20160629_010001bee_master_20160630_010001bee_master_20160701_010001bee_master_20160702_010001bee_master_20160703_010001bee_master_20160704_010001bee_master_20160705_010001bee_master_20160706_010001bee_master_20160707_010001bee_master_20160707_040048bee_master_20160708_010001bee_master_20160709_010001bee_master_20160710_010001bee_master_20160711_010001bee_master_20160712_010001bee_master_20160713_010001bee_master_20160714_010001bee_master_20160715_010002bee_master_20160716_010001bee_master_20160717_010001bee_master_20160718_010001bee_master_20160720_010001bee_master_20160721_010001bee_master_20160723_010002bee_master_20160724_010001bee_master_20160725_010001bee_master_20160726_010001bee_master_20160727_010002bee_master_20160728_010001bee_master_20160729_010001bee_master_20160730_010001bee_master_20160731_010001bee_master_20160801_010001bee_master_20160802_010001bee_master_20160803_010001, Created # PySpark Usage Guide for Pandas with Apache Arrow, Specifying storage format for Hive tables, Interacting with Different Versions of Hive Metastore. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. 5 What happened when a managed table is dropped? When the. HIVE TO TABLE HONEY ORGANIC NON GMO Advertising Vinyl Banner Flag Sign Many Size best prices, best service. How do I tell hive about file formats in HDFS? 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
ORC versus Parquet compression and response time - IT World 07-10-2018 # | 4| val_4| 4| val_4| in OLAP and OLTP environment along with DB role . # | 5| val_5| 5| val_5| This command shows meta data about the hive table which includes list of columns,data types and location of the table.There are three ways to describe a table in Hive. It provides client access to this information by using metastore service API. Data in each partition may be furthermore divided into Buckets. 1. find out the path of the hive tables: for example, find the path for table r_scan1, The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". # |count(1)| Here are the types of tables in Apache Hive: Managed Tables. You can also use queryExecution.analyzed.stats to return the size. Thanks for contributing an answer to Stack Overflow! will compile against built-in Hive and use those classes for internal execution (serdes, UDFs, UDAFs, etc). I ran the suggested command but i see size as 0 whereas i know it has some data. CREATE TABLE src(id int) USING hive OPTIONS(fileFormat 'parquet'). [jira] [Updated] (HIVE-19334) Use actual file size rather than stats for fetch task optimization with external tables. Partitioning Tables: Hive partitioning is an effective method to improve the query performance on larger tables. By default hive1 database Hive Metastore DB, execute the following query to get the total size of all the tables in Hive in bytes for one replica, multiply it by replication factor. // Order may vary, as spark processes the partitions in parallel. When you run DROP TABLE on an external table, by default Hive drops only the metadata (schema). # The items in DataFrames are of type Row, which allows you to access each column by ordinal. In a managed table, both the table data and the table schema are managed by Hive. of Hive that Spark SQL is communicating with. These cookies track visitors across websites and collect information to provide customized ads. Analytical cookies are used to understand how visitors interact with the website. # Key: 0, Value: val_0 What is Hive Temporary Tables? The LENGTH function in Big SQL counts bytes, whereas LENGTH function in Hive counts characters. I tried Googling and searching the apache.org documentation without success.).
HOW TO: Find Total Size of Hive Database/Tables in BDM? - Informatica The data loaded in the hive database is stored at the HDFS path /user/hive/warehouse. (40) (140) adds support for finding tables in the MetaStore and writing queries using HiveQL. so the Hive system will know about any changes to the underlying data and can update the stats accordingly. How to limit parquet file dimension for a parquet table in hive? Checking the different parameters of the table in Hive Metastore table TABLE_PARAMS for the same Hive table with id 5783. We are able to use the Tblproperties, or tbldescription. Use hdfs dfs -du Command Hive supports ANSI SQL and atomic, consistent, isolated, and durable (ACID) transactions. hive.mapjoin.localtask.max.memory.usage. Login into Hive Metastore DB and use the database that is used by hive. Default Value: 0.90; Added In: Hive 0.7.0 with HIVE-1808 and HIVE-1642 Switch to the Hive schema and issue the SHOW TABLES command to see the Hive tables that exist. the serde. For example, Hive UDFs that are declared in a Hive stores query logs on a per Hive session basis in /tmp/<user.name>/ by default. 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; GZIP. Managed Table/Internal Table. creates a directory configured by spark.sql.warehouse.dir, which defaults to the directory How do I align things in the following tabular environment? 01-17-2017 Mutually exclusive execution using std::atomic? 12:25 PM Tables created by oozie hive action cannot be found from hive client but can find them in HDFS. As far as I know there is no single command to achieve the results you're looking. - the incident has nothing to do with me; can I use this this way? There are some hidden intermediate file so it doesn't match du number, Created If the PURGE option is not specified, the data is moved to a trash folder for a defined duration. prefix that typically would be shared (i.e. Difference between Hive internal tables and external tables? Prerequisites The Hive and HDFS components are running properly. 324 and 972 are the sizes of one and three replicas of the table data in HDFS. This Otherwise, hdfs dfs -du -s -h /path/to/table will do. The table is storing the records or data in tabular format. Find answers, ask questions, and share your expertise, Hive explain Table Parameters: totalSize doesn't match actual file size. Is there a way to enforce compression on table itself? When not configured Why is this sentence from The Great Gatsby grammatical? The query takes the sum of total size of all the Hive tables based on the statistics of the tables. 24/7 Customer Service Great Quality at Low Prices Compare Lowest Prices Reusable Hive Baitable Beetle Trap Without Poison Chemicals Beekeeping Tool SH dynatech.co.tz, US $3.94 Size About Length Width : 17 13 cm United States United Kingdom Item No : 2015520 Rate (item arrived) hope you could understand Color : As . 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. Provides High compression ratio (even higher than GZIP). ; external table and internal table. Hive is a very important component or service in the Hadoop stack. How can I delete a hive database without using hive terminal? Jason Dere (JIRA) . Necessary cookies are absolutely essential for the website to function properly. In the hive, the tables are consisting of columns and rows and store the related data in the table format within the same database.
Hive table | Databricks on AWS BZIP2. 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). 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. For external tables Hive assumes that it does not manage the data. # |key| value|key| value| The cookies is used to store the user consent for the cookies in the category "Necessary". When you create a Hive table, you need to define how this table should read/write data from/to file system, i.e. Hive is an ETL and Data warehousing tool developed on top of the Hadoop Distributed File System. 01-16-2017 How do you know if a hive table is internal or external? 01-13-2017
Jitendra Kumar Shahi - Technical Architect - FIS | LinkedIn 07-05-2018
PySpark SQL Read Hive Table - Spark By {Examples} HOW TO: Find Total Size of Hive Database/Tables in BDM? 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.
How Do I Monitor the Hive Table Size?_MapReduce Service_Component The company is the world's leading enterprise resource planning (ERP) software vendor.
Share Hive Metastore with Azure Synapse Spark Pool The next point which is the hdfs du -s can be compared to check this. 01-13-2017 Hive simplifies the performance of operations such as: Data encapsulation Ad-hoc queries Analysis of huge datasets But what makes Hive standout?
GIF - Wikipedia I am looking for a approach to run a command and get all required info. hive> describe extended bee_master_20170113_010001> ;OKentity_id stringaccount_id stringbill_cycle stringentity_type stringcol1 stringcol2 stringcol3 stringcol4 stringcol5 stringcol6 stringcol7 stringcol8 stringcol9 stringcol10 stringcol11 stringcol12 string, Detailed Table Information Table(tableName:bee_master_20170113_010001, dbName:default, owner:sagarpa, createTime:1484297904, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:entity_id, type:string, comment:null), FieldSchema(name:account_id, type:string, comment:null), FieldSchema(name:bill_cycle, type:string, comment:null), FieldSchema(name:entity_type, type:string, comment:null), FieldSchema(name:col1, type:string, comment:null), FieldSchema(name:col2, type:string, comment:null), FieldSchema(name:col3, type:string, comment:null), FieldSchema(name:col4, type:string, comment:null), FieldSchema(name:col5, type:string, comment:null), FieldSchema(name:col6, type:string, comment:null), FieldSchema(name:col7, type:string, comment:null), FieldSchema(name:col8, type:string, comment:null), FieldSchema(name:col9, type:string, comment:null), FieldSchema(name:col10, type:string, comment:null), FieldSchema(name:col11, type:string, comment:null), FieldSchema(name:col12, type:string, comment:null)], location:hdfs://cmilcb521.amdocs.com:8020/user/insighte/bee_data/bee_run_20170113_010001, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{field.delim= , serialization.format=Time taken: 0.328 seconds, Fetched: 18 row(s)hive> describe formatted bee_master_20170113_010001> ;OK# col_name data_type comment, entity_id stringaccount_id stringbill_cycle stringentity_type stringcol1 stringcol2 stringcol3 stringcol4 stringcol5 stringcol6 stringcol7 stringcol8 stringcol9 stringcol10 stringcol11 stringcol12 string, # Detailed Table InformationDatabase: defaultOwner: sagarpaCreateTime: Fri Jan 13 02:58:24 CST 2017LastAccessTime: UNKNOWNProtect Mode: NoneRetention: 0Location: hdfs://cmilcb521.amdocs.com:8020/user/insighte/bee_data/bee_run_20170113_010001Table Type: EXTERNAL_TABLETable Parameters:COLUMN_STATS_ACCURATE falseEXTERNAL TRUEnumFiles 0numRows -1rawDataSize -1totalSize 0transient_lastDdlTime 1484297904, # Storage InformationSerDe Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDeInputFormat: org.apache.hadoop.mapred.TextInputFormatOutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormatCompressed: NoNum Buckets: -1Bucket Columns: []Sort Columns: []Storage Desc Params:field.delim \tserialization.format \tTime taken: 0.081 seconds, Fetched: 48 row(s)hive> describe formatted bee_ppv;OK# col_name data_type comment, entity_id stringaccount_id stringbill_cycle stringref_event stringamount doubleppv_category stringppv_order_status stringppv_order_date timestamp, # Detailed Table InformationDatabase: defaultOwner: sagarpaCreateTime: Thu Dec 22 12:56:34 CST 2016LastAccessTime: UNKNOWNProtect Mode: NoneRetention: 0Location: hdfs://cmilcb521.amdocs.com:8020/user/insighte/bee_data/tables/bee_ppvTable Type: EXTERNAL_TABLETable Parameters:COLUMN_STATS_ACCURATE trueEXTERNAL TRUEnumFiles 0numRows 0rawDataSize 0totalSize 0transient_lastDdlTime 1484340138, # Storage InformationSerDe Library: org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDeInputFormat: org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormatOutputFormat: org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormatCompressed: NoNum Buckets: -1Bucket Columns: []Sort Columns: []Storage Desc Params:field.delim \tserialization.format \tTime taken: 0.072 seconds, Fetched: 40 row(s), Created path is like /FileStore/tables/your folder name/your file; Refer to the image below for example. This summary is aimed for those who don't have the current time to devour all 256 pages. rawDataSize: 05:38 PM, Created Hive is an ETL and Data warehousing tool developed on top of Hadoop Distributed File System (HDFS). What is the safe score in JEE Mains 2021? Can we check size of Hive tables? Compressed file size should not be larger than a few hundred megabytes. To learn more, see our tips on writing great answers. Why are physically impossible and logically impossible concepts considered separate in terms of probability? the hive.metastore.warehouse.dir property in hive-site.xml is deprecated since Spark 2.0.0. It is providing the MySQL solution on top of the HDFS data. Then you will get quicker results. The Mail Archive home; issues - all . Afrikaans; ; Azrbaycanca; ; ; Bosanski; Catal; etina; Cymraeg; Dansk; Deutsch; Eesti; . if the table is partitioned, we can count the number of partitions and count(number of rows) in each partition. - the incident has nothing to do with me; can I use this this way. # | 86| val_86| If a managed table or partition is dropped, the data and metadata associated with that table or partition are deleted.
Find the size of a table - Databricks Why keep stats if we cant trust that the data will be the same in another 5 minutes? Yes the output is bytes. Apparently the given command only works when these properties are available to the column, which is not there by default. numRows: All other properties defined with OPTIONS will be regarded as Hive serde properties. Location of the jars that should be used to instantiate the HiveMetastoreClient.
Coding Zone How to show hive table size in GB See other answer below. It is difficult to find table size in hive using query. The threshold (in bytes) for the input file size of the small tables; if the file size is smaller than this threshold, it will try to convert the common join into map join. When working with Hive, one must instantiate SparkSession with Hive support, including The output should be including below fields: The benchmark compares all the SQL systems embedded with HDP3 as well as Hive on MR3 (a new execution engine for Hadoop and Kubernetes), by running a set of 99 SQL queries. Does a summoned creature play immediately after being summoned by a ready action? this return nothing in hive. so the Hive system will know about any changes to the underlying data and can update the stats accordingly. However I ran the hdfs command and got two sizes back. Any help please? These cookies ensure basic functionalities and security features of the website, anonymously. 09:28 AM, Du return 2 number. 3 Describe formatted table_name: 3.1 Syntax: 3.2 Example: We can see the Hive tables structures using the Describe commands. What are the compression techniques in Hive? 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. # +--------+ When you create a Hive table, you need to define how this table should read/write data from/to file system, connectivity to a persistent Hive metastore, support for Hive serdes, and Hive user-defined functions. be shared is JDBC drivers that are needed to talk to the metastore. The HDFS refined monitoring function is normal. 11:46 AM, Du return 2 number. # +---+-------+ // You can also use DataFrames to create temporary views within a SparkSession. # Queries can then join DataFrame data with data stored in Hive. If so, how? The nature of simulating nature: A Q&A with IBM Quantum researcher Dr. Jamie We've added a "Necessary cookies only" option to the cookie consent popup. Hive supports tables up to 300PB in Optimized Row Columnar (ORC) format. // warehouseLocation points to the default location for managed databases and tables, "CREATE TABLE IF NOT EXISTS src (key INT, value STRING) USING hive", "LOAD DATA LOCAL INPATH 'examples/src/main/resources/kv1.txt' INTO TABLE src". Also, this only works for non-partitioned tables which have had stats run on them. You also have the option to opt-out of these cookies. Articles Related Column Directory Hierarchy The partition columns determine how the d ". Open Sourcing Clouderas ML Runtimes - why it matters to customers? -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.