https://community.cloudera.com/t5/Support-Questions/HIVE-External-Tables/m-p/235592#M197405 <P>Here is the HDFS folder structure - /FLIGHT/2019/03/01/XYZ.tsv, /FLIGHT/2019/03/02/XYZ.tsv, /FLIGHT/2019/03/03/XYZ.tsv etc. While declaring HIVE external table LOCATION can we use something like /FLIGHT/{*<EM>}/{*</EM>}/{*}XYZ.tsv.</P><P>Basically, we just have to read all files that match that specific pattern. Thanks for your feedback.</P> Thu, 14 Mar 2019 04:48:56 GMT rajuravindra 2019-03-14T04:48:56Z https://community.cloudera.com/t5/Support-Questions/HIVE-External-Tables/m-p/235592#M197405 <P>Here is the HDFS folder structure - /FLIGHT/2019/03/01/XYZ.tsv, /FLIGHT/2019/03/02/XYZ.tsv, /FLIGHT/2019/03/03/XYZ.tsv etc. While declaring HIVE external table LOCATION can we use something like /FLIGHT/{*<EM>}/{*</EM>}/{*}XYZ.tsv.</P><P>Basically, we just have to read all files that match that specific pattern. Thanks for your feedback.</P> Thu, 14 Mar 2019 04:48:56 GMT https://community.cloudera.com/t5/Support-Questions/HIVE-External-Tables/m-p/235592#M197405 rajuravindra 2019-03-14T04:48:56Z https://community.cloudera.com/t5/Support-Questions/HIVE-External-Tables/m-p/235593#M197406 <P>You just need to align your LOCATION clause of EXTERNALS TABLE's DDL to point to your /FLIGHT folder. Hive will crawl all the subfolders. </P><P>You might also consider using PARTITION BY and instead of having folders for year, month a day. This let's you do things like WHERE my_partition_col &gt; '19991115' AND my_partition_col &lt; '20010215' which would be much tougher if you partition by specific year, month, and day values.</P> Mon, 18 Mar 2019 21:55:16 GMT https://community.cloudera.com/t5/Support-Questions/HIVE-External-Tables/m-p/235593#M197406 LesterMartin 2019-03-18T21:55:16Z