Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> External table with partitions

Copy link to this message
Re: External table with partitions
If all files are in same partition then they satisfy condition of same
value as partion column .

You cannot do with hive but can have one intermediate table and then to
move required files using glob pattern

Sent from Mobile , short and crisp.
On 07-Jan-2013 1:07 AM, "Oded Poncz" <[EMAIL PROTECTED]> wrote:

> Is it possible to instruct hive to get only specific files from a
> partitioned external table?
> For example I have the following directory structure
> data/dd=2012-12-31/a1.txt
> data/dd=2012-12-31/a2.txt
> data/dd=2012-12-31/a3.txt
> data/dd=2012-12-31/a4.txt
> data/dd=2012-12-31/b1.txt
> data/dd=2012-12-31/b2.txt
> data/dd=2012-12-31/b2.txt
> Is it possible to add 2012-12-31 as a partition and tell hive to load only
> the a* files to the table?
> Thanks,