alter table add partition should work
see:
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL
-- amr
On 6/26/2010 3:15 AM, Shuja Rehman wrote:
Hi
I have a Questions about external tables
Suppose I have this kind of directory structure in hdfs.
/user/Mydata/Data1/part-000
/user/Mydata/Data1/part-001
/user/Mydata/Data1/part-002
...
1- I have created the external table and point to directory
"/user/Mydata/Data1" of hdfs to load data. Hive will load the data
from all files in this folder while creating the table. Now suppose
the new directories are created in the same location like this
/user/Mydata/Data2/part-000
/user/Mydata/Data2/part-001
.....
Now, Data2 directory is created in the Mydata directory. how to load
data from this new directory into same table?
--
Regards
Shuja-ur-Rehman Baig
_________________________________
MS CS - School of Science and Engineering
Lahore University of Management Sciences (LUMS)
Sector U, DHA, Lahore, 54792, Pakistan
Cell: +92 3214207445