Hi Oded 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. Regards Bejoy KS Sent from remote device, Please excuse typos -----Original Message----- 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 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,
