add partition

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 st

Re: add partition

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 a

alter table add partition error

Hi, I am trying to create an external table against already existing data in sequencefile format. However I have written a custom Serde to interpret the data. I am able to create the table fine but get the exception shown in the session output below when I try to add partition - any help

Re: alter table add partition error

efile format. However I have written a custom Serde to interpret > the data. I am able to create the table fine but get the exception shown in > the session output below when I try to add partition – any help would be > greatly appreciated. > > > > Thanks, > > Pradeep >

RE: alter table add partition error

- any help would be greatly appreciated! Thanks, Pradeep From: yq he [mailto:hhh.h...@gmail.com] Sent: Wednesday, June 16, 2010 5:54 PM To: hive-user@hadoop.apache.org Subject: Re: alter table add partition error Hi Pradeep, partition definition

RE: alter table add partition error

hmm... Can you send the exact command and also the create table command for this table. Ashish From: Pradeep Kamath [mailto:prade...@yahoo-inc.com] Sent: Thursday, June 17, 2010 9:09 AM To: hive-user@hadoop.apache.org Subject: RE: alter table add partition error

RE: alter table add partition error

'; hive --auxpath ult-serde.jar -e "ALTER TABLE mytable add partition(datestamp = '20091101', srcid = '19174',action='click',testid='NOTESTID') location '/user/pradeepk/mytable/20091101/19174/click/NOTESTID';" I get the following e

RE: alter table add partition error

perties of core-default.xml, mapred-default.xml and hdfs-default.xml respectively Hive history file=/tmp/pradeepk/hive_job_log_pradeepk_201006181013_184583537.txt OK Time taken: 0.627 seconds hive -e "ALTER TABLE dummy add partition(datestamp = '20100602', srcid = '

Re: alter table add partition error

cated. Instead use core-site.xml, mapred-site.xml and hdfs-site.xml to override properties of core-default.xml, mapred-default.xml and hdfs-default.xml respectively Hive history file=/tmp/pradeepk/hive_job_log_pradeepk_201006181013_184583537.txt OK Time taken: 0.627 seconds hive -e "ALTER TA

Re: alter table add partition error

stead use > core-site.xml, mapred-site.xml and hdfs-site.xml to override properties of > core-default.xml, mapred-default.xml and hdfs-default.xml respectively > > Hive history > file=/tmp/pradeepk/hive_job_log_pradeepk_201006181013_184583537.txt > > OK > > Time t

RE: alter table add partition error

st thrift and how to upgrade. JVS From: Pradeep Kamath [prade...@yahoo-inc.com] Sent: Wednesday, June 23, 2010 9:03 AM To: hive-user@hadoop.apache.org Subject: RE: alter table add partition error In the second step of http://wiki.apache.org/hadoop/

why alter table tbl add partition(...) location ... need write permission to the target location?

Hey guys, I tried to add an external partition for my web_log table, but failed like below, hive> ALTER TABLE web_log ADD PARTITION (logdate='20090519') LOCATION '/user/zhoumin/web_log/20090519/'; FAILED: Error in metadata: MetaExceptio

Re: why alter table tbl add partition(...) location ... need write permission to the target location?

Sorry, my bad! the directory I loaded isn't exists yet. On Wed, May 20, 2009 at 4:10 PM, Min Zhou wrote: > Hey guys, > > I tried to add an external partition for my web_log table, but failed like > below, > > hive> ALTER TABLE web_log ADD PARTITION (logdate='20090