Hi Natraj

Create a partitioned table and add the sub dirs as partitions. You need to have some logic in place for determining the partitions. Say if the sub dirs denote data based on a date then make date as the partition.

Regards
Bejoy KS

Sent from handheld, please excuse typos.

From: Nataraj Rashmi - rnatar <Rashmi.Nataraj@acxiom.com>
Date: Wed, 12 Sep 2012 19:19:19 +0000
To: user@hadoop.apache.org<user@hadoop.apache.org>
ReplyTo: user@hadoop.apache.org
Subject: How to make the hive external table read from subdirectories

I have a hive external table created from a hdfs location. How do I make it read the data from all  the subdirectories also?

 

Thanks.

***************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be legally
privileged.

If the reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank You.
****************************************************************************