> 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,>

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.

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.