Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive, mail # user - External Table


+
Shuja Rehman 2010-06-26, 10:15
Copy link to this message
-
Re: External Table
Amr Awadallah 2010-06-27, 22:28
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