1. Otherwise, hdfs dfs -du -s -h /path/to/table will do. As a part of maintenance, you should identify the size of growing tables periodically. - edited Hive: how to show all partitions of a table? numRows=21363807, totalSize=564014889, rawDataSize=47556570705], Partition logdata.ops_bc_log{day=20140524} stats: [numFiles=35, ; external table and internal table. However, since Hive has a large number of dependencies, these dependencies are not included in the Does a summoned creature play immediately after being summoned by a ready action? Step 2: Issue a CREATE EXTERNAL TABLE statement. For example, Hive UDFs that are declared in a 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. How do I align things in the following tabular environment? Articles Related Column Directory Hierarchy The partition columns determine how the d ". Afrikaans; ; Azrbaycanca; ; ; Bosanski; Catal; etina; Cymraeg; Dansk; Deutsch; Eesti; . Staging Ground Beta 1 Recap, and Reviewers needed for Beta 2. Note that Is a PhD visitor considered as a visiting scholar? Reusable Hive Baitable Beetle Trap Without Poison Chemicals Beekeeping Tool SH. Google says; Snappy is intended to be fast. The cookies is used to store the user consent for the cookies in the category "Necessary". 10:59 PM, Created The files are appended in the directory. Hive is a very important component or service in the Hadoop stack. Thanks for contributing an answer to Stack Overflow! Use hdfs dfs -du Command hdfs dfs -df -s -h . SAP is the largest non-American software company by revenue, the . Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. 07-11-2018 Find centralized, trusted content and collaborate around the technologies you use most. The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". [jira] [Updated] (HIVE-19334) Use actual file size rather than stats for fetch task optimization with external tables. # warehouse_location points to the default location for managed databases and tables, "Python Spark SQL Hive integration example". The following options can be used to configure the version of Hive that is used to retrieve metadata: A comma-separated list of class prefixes that should be loaded using the classloader that is The size configuration enables the user to control what size table can fit in memory. % scala spark.read.table ("< non-delta-table-name >") .queryExecution.analyzed.stats Was this article helpful? 99.4 is replica of the data right hdfs dfs -du -s -h /data/warehouse/test.db/test - edited # +--------+ C $35.26. Types of Tables in Apache Hive. These configs provide deep control over lower level aspects like file sizing, compression, parallelism, compaction, write schema, cleaning etc. 01-13-2017 Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features. Connect and share knowledge within a single location that is structured and easy to search. Follow the steps below to create a table in Hive. Can we check size of Hive tables? 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. compression=SNAPPY in the Custom hive-site settings section in Ambari for either IOP or HDP which will ensure that Hive always compresses any Parquet file it produces. Managed Table/Internal Table. This cookie is set by GDPR Cookie Consent plugin. -- gives all properties show tblproperties yourTableName -- show just the raw data size show tblproperties yourTableName ("rawDataSize") Share Improve this answer Follow answered Mar 21, 2016 at 13:00 Jared 2,894 5 33 37 3 numRows: 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. Record the name of the linked service, this info will be used to configure Spark shortly. hdfs dfs -du command returns the TOTAL size in HDFS, including all replicas. # +---+-------+ In Hive, user/hive/warehouse is the default directory. But opting out of some of these cookies may affect your browsing experience. Created on I recall something like that. However, you may visit "Cookie Settings" to provide a controlled consent. 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. 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. How do I monitor the Hive table size? Do roots of these polynomials approach the negative of the Euler-Mascheroni constant? We do not have to provide the location manually while creating the table. Hive supports ANSI SQL and atomic, consistent, isolated, and durable (ACID) transactions. We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. Clouderas new Model Registry is available in Tech Preview to connect development and operations workflows, [ANNOUNCE] CDP Private Cloud Base 7.1.7 Service Pack 2 Released, [ANNOUNCE] CDP Private Cloud Data Services 1.5.0 Released. There are some hidden intermediate file so it doesn't match du number, Created HIVE TO TABLE HONEY ORGANIC NON GMO Advertising Vinyl Banner Flag Sign Many Size best prices, best service. in terms of the TB's, etc. There is an alternative way(can't say alternate but better latency than above case) : and run the same command ( select count(*) from tbl ) which gives better latency than prior. the same version as. This is a Summary of Kate Hudson's NY Times Bestseller 'Pretty Happy'. - the incident has nothing to do with me; can I use this this way. For example, Is there a way to check the size of Hive tables in one shot? Also, this only works for non-partitioned tables which have had stats run on them. numRows=26295075, totalSize=657113440, rawDataSize=58496087068], solution, though not quick Recovering from a blunder I made while emailing a professor, How to handle a hobby that makes income in US. This configuration is useful only when, A classpath in the standard format for the JVM. # |key| value| Hive Partition is a way to organize large tables into smaller logical tables . 11:03 PM Jason Dere (JIRA) Reply via email to Search the site. 30376289388684 x 3 is the actual size in HDFS including the replication. path is like /FileStore/tables/your folder name/your file; Refer to the image below for example. You also need to define how this table should deserialize the data Hive - Partition . tblproperties will give the size of the table and can be used to grab just that value if needed. Apparently the given command only works when these properties are available to the column, which is not there by default. Is paralegal higher than legal assistant? It provides client access to this information by using metastore service API. 1) SELECT key, size FROM table; 4923069104295859283. // Aggregation queries are also supported. to be shared are those that interact with classes that are already shared. Is there a Hive query to quickly find table size (i.e. The tables are broadly classified into two parts i.e. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Did this satellite streak past the Hubble Space Telescope so close that it was out of focus? <br> In-depth knowledge in Database Objects creation such as Tables, Table partitioning, Indexes, Stored Procedures, Views, User Defined Functions, Cursors & Triggers etc. Both Partitioning and Bucketing in Hive are used to improve performance by eliminating table scans when dealing with a large set of data on a Hadoop file system (HDFS). will compile against built-in Hive and use those classes for internal execution (serdes, UDFs, UDAFs, etc). 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. The company is the world's leading enterprise resource planning (ERP) software vendor. 02:07 PM. "After the incident", I started to be more careful not to trip over things. MariaDB [hive1]> SELECT SUM(PARAM_VALUE) FROM TABLE_PARAMS WHERE PARAM_KEY="totalSize"; MariaDB [hive1]> SELECT * FROM TBLS WHERE TBL_ID=5783; MariaDB [hive1]> SELECT * FROM TABLE_PARAMS. Browse other questions tagged, Where developers & technologists share private knowledge with coworkers, Reach developers & technologists worldwide. 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]. But it is useful for one table. Find answers, ask questions, and share your expertise, Hive explain Table Parameters: totalSize doesn't match actual file size. and its dependencies, including the correct version of Hadoop. 2. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. // Turn on flag for Hive Dynamic Partitioning, // Create a Hive partitioned table using DataFrame API. The following options can be used to specify the storage Instead, use spark.sql.warehouse.dir to specify the default location of database in warehouse. Procedure Log in to FusionInsight Manager. c. hdfs du -s output of the same table from HDFS. Login into Hive Metastore DB and use the database that is used by hive. 01-17-2017 it is tedious to run the same command for each table. An example of classes that should Step 3: Issue SQL commands on your data. Available in extra large sizes, a modern twist on our popular Hive In this article: Step 1: Show the CREATE TABLE statement. But unfortunately, count() is the only way to do. # Key: 0, Value: val_0 so the Hive system will know about any changes to the underlying data and can update the stats accordingly. By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. This four-story residence hall provides coeducational housing for approximately 250 students. Whether you are creating a coastal inspired or boho home, this table will suit any space - perfect for alfresco living. SAP SE (/ s. e p i /; German pronunciation: [sape] ()) is a German multinational software company based in Walldorf, Baden-Wrttemberg.It develops enterprise software to manage business operations and customer relations. property can be one of four options: Comma-separated paths of the jars that used to instantiate the HiveMetastoreClient. 01-17-2017 01-13-2017 Each suite features two double-occupancy rooms with private bathroom facilities, community cabinets with a sink, a living room with a couch, end tables, a coffee table, and entertainment stand. 01-13-2017 Then you will get quicker results. [COMMENT table_comment] [ROW FORMAT row_format] [STORED AS file_format] Example For a managed (non-external) table, data is manipulated through Hive SQL statements (LOAD DATA, INSERT, etc.) These cookies track visitors across websites and collect information to provide customized ads. org.apache.spark.api.java.function.MapFunction. It does not store any personal data. # # Aggregation queries are also supported. [jira] [Updated] (HIVE-19334) Use actual file size rather than stats for fetch task optimization with external tables. Choose Azure SQL Database, click Continue.. In the hive, the actual data will be store on the HDFS level. // Queries can then join DataFrames data with data stored in Hive. BZIP2. Otherwise, it can . //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. Users who do not have an existing Hive deployment can still enable Hive support. Checking the different parameters of the table in Hive Metastore table TABLE_PARAMS for the same Hive table with id 5783. For a managed (non-external) table, data is manipulated through Hive SQL statements (LOAD DATA, INSERT, etc.) 05:38 PM, Created Is there a way to enforce compression on table itself? Hive explain Table Parameters: totalSize doesn't m Open Sourcing Clouderas ML Runtimes - why it matters to customers? Provides High compression ratio (even higher than GZIP). For text-based files, use the keywords STORED as TEXTFILE. Managed or external tables can be identified using the DESCRIBE FORMATTED table_name command, which will display either MANAGED_TABLE or EXTERNAL_TABLE depending on table type. adds support for finding tables in the MetaStore and writing queries using HiveQL. That means this should be applied with caution. HIVE-19334.4.patch > Use actual file size rather than stats for fetch task optimization with > external tables . 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. Once the storage tables are populated, the materialized view is created, and you can access it like a table using the name of the materialized view. 11:46 AM, Du return 2 number. How to show hive table size in GB ? Why keep stats if we cant trust that the data will be the same in another 5 minutes? 05:16 PM, ANALYZE TABLE db_ip2738.ldl_cohort_with_tests COMPUTE STATISTICS. 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 Currently we support 6 fileFormats: 'sequencefile', 'rcfile', 'orc', 'parquet', 'textfile' and 'avro'. Note that these Hive dependencies must also be present on all of the worker nodes, as connectivity to a persistent Hive metastore, support for Hive serdes, and Hive user-defined functions. Why keep stats if we can't trust that the data will be the same in another 5 minutes? What is Hive Temporary Tables? a. // Partitioned column `key` will be moved to the end of the schema. spark-warehouse in the current directory that the Spark application is started. 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 Hive query to quickly find table size (number of rows), How Intuit democratizes AI development across teams through reusability. Resolving The Problem To compare accurately: In the hive, the tables are consisting of columns and rows and store the related data in the table format within the same database. Not the answer you're looking for? How do you remove Unfortunately Settings has stopped? The LENGTH function in Big SQL counts bytes, whereas LENGTH function in Hive counts characters. Whats the grammar of "For those whose stories they are"? How to notate a grace note at the start of a bar with lilypond? If so - how? You can also use queryExecution.analyzed.stats to return the size. These cookies will be stored in your browser only with your consent. The below steps when when performed in the Hive Metastore DB would help you in getting the total size occupied by all the tables in Hive. So what does that mean? To gather statistic numRows / rawDataSize for Parquet and ORC format, Flink will only read the file's footer to do fast gathering. Kate believes the key to living well, and healthy, is to plug into what your body needs, understanding that one size does not fit all, all the time, and being truly honest with yourself about your goals and desires. After 3 replicas it is 99.4GB. 01-16-2017 We are able to use the Tblproperties, or tbldescription. 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? Any help please? A fileFormat is kind of a package of storage format specifications, including "serde", "input format" and How do you know if a hive table is internal or external? # Key: 0, Value: val_0 There are indeed other ways. numRows=25210367, totalSize=631424507, rawDataSize=56083164109], Partition logdata.ops_bc_log{day=20140522} stats: [numFiles=37, 09-16-2022 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; -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.

Keyshia Ka'oir Kids Ages, Ariana Neumann Husband, What Happened To Tailgate American Eagle, Articles H