-Re: External table with partitions
bejoy_ks@... 2013-01-06, 14:39
If you have created the directories manually that would come visible to the hive table only if the partitions/ sub dirs are added to the meta data using
'ALTER TABLE ... ADD PARTITION' .
Partitions are not retrieved implicitly into hive tabe even if you have a proper sub dir structure.
Similarly if you don't need a particular partition on your table permanently you can always delete them using the alter table command.
If you are intending to use a particular partition alone in your query no need to alter the partitions. Just append a where clause to the query that has scope only on the required partitions.
Hope this helps.
Sent from remote device, Please excuse typos
From: Oded Poncz <[EMAIL PROTECTED]>
Date: Sun, 6 Jan 2013 16:07:26
To: <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Subject: External table with partitions
Is it possible to instruct hive to get only specific files from a
partitioned external table?
For example I have the following directory structure
Is it possible to add 2012-12-31 as a partition and tell hive to load only
the a* files to the table?