External Table

[Shuja Rehman <sh...@gmail.com>]

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

Re: External Table

[Amr Awadallah <aa...@cloudera.com>]

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