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

Switch to Threaded View
Hive, mail # user - add partition

Copy link to this message
Re: add partition
Thiruvel Thirumoolan 2010-09-19, 18:18
You can specify the location of a partition while adding one. Location should be a directory though.

ALTER TABLE test ADD PARTITION(pt='01' ) LOCATION '/user/hive/warehouse/user'

On Sep 19, 2010, at 1:33 PM, lei liu wrote:

I use below statement to create one tabale and add one partition:
create external table test(userid bigint,name string, age int) partitioned by(pt string);
alter table test add partition(pt='01');
Now there is one file in HDFS, the file path is /user/hive/warehouse/user, I use load statement to load the file to partition: load data inpath '/user/hive/warehouse/user'  into table test partition(pt='01'). I find the file path is changed, form /user/hive/warehouse/user to /user/hive/warehouse/test/pt=01. I want to do't change the file path, how can I do it?