Re: Hive partition problem

2012-05-31 Thread wd
n it came to dropping 1 partition for an hour for a particular day, it > seemed to drop all of the hour partitions for the day. > > IMO it's a bug. We just moved to using text > > > Malc > > > -Original Message- > From: wd [mailto:w...@wdicc.com] > Sent:

RE: Hive partition problem

2012-05-31 Thread Malcolm Tye
c -Original Message- From: wd [mailto:w...@wdicc.com] Sent: 31 May 2012 09:32 To: user@hive.apache.org Subject: Re: Hive partition problem Is this a bug? Should I report a bug to hive? On Thu, May 31, 2012 at 3:56 PM, wd wrote: > Still no useful output. But we found the problem. >

Re: Hive partition problem

2012-05-31 Thread wd
Is this a bug? Should I report a bug to hive? On Thu, May 31, 2012 at 3:56 PM, wd wrote: > Still no useful output. But we found the problem. > > When the partition col type is int, it can't be droped. After change > it to string, it can be droped. > > On Thu, May 31, 2012 at 3:48 PM, Aniket Mokas

Re: Hive partition problem

2012-05-31 Thread wd
Still no useful output. But we found the problem. When the partition col type is int, it can't be droped. After change it to string, it can be droped. On Thu, May 31, 2012 at 3:48 PM, Aniket Mokashi wrote: > -hiveconf hive.root.logger=DEBUG,FA \ >     -hiveconf hive.log.dir="$logDir" \ >     -hi

Re: Hive partition problem

2012-05-31 Thread Aniket Mokashi
-hiveconf hive.root.logger=DEBUG,FA \ -hiveconf hive.log.dir="$logDir" \ -hiveconf hive.log.file="$logFile" \ On Thu, May 31, 2012 at 12:41 AM, wd wrote: > Nothing output in hive history file, is there an other log file or an > option to output detail log ? > > On Thu, May 31, 2012 at 3:

Re: Hive partition problem

2012-05-31 Thread wd
Nothing output in hive history file, is there an other log file or an option to output detail log ? On Thu, May 31, 2012 at 3:34 PM, Aniket Mokashi wrote: > You should look at hive log and find exact exception. That will give you a > hint. > > > On Thu, May 31, 2012 at 12:33 AM, wd wrote: >> >>

Re: Hive partition problem

2012-05-31 Thread Aniket Mokashi
You should look at hive log and find exact exception. That will give you a hint. On Thu, May 31, 2012 at 12:33 AM, wd wrote: > No problem, thanks for your reply. > I'm very curious why this didn't work, this sql come from hive wiki. > The metadata is store in postgres, does it matter? > > On Thu

Re: Hive partition problem

2012-05-31 Thread wd
No problem, thanks for your reply. I'm very curious why this didn't work, this sql come from hive wiki. The metadata is store in postgres, does it matter? On Thu, May 31, 2012 at 3:26 PM, Bhavesh Shah wrote: > Sorry for previous reply. Actually you had try that one, I didn't saw that. > Really So

Re: Hive partition problem

2012-05-31 Thread Bhavesh Shah
Sorry for previous reply. Actually you had try that one, I didn't saw that. Really Sorry. On Thu, May 31, 2012 at 12:53 PM, Bhavesh Shah wrote: > Hello wd, > Try this one... I am not sure about this > ALTER TABLE t1 DROP PARTITION(dt = '111') > > > -- > Regards, > Bhavesh Shah > > > On Thu, May 3

Re: Hive partition problem

2012-05-31 Thread Bhavesh Shah
Hello wd, Try this one... I am not sure about this ALTER TABLE t1 DROP PARTITION(dt = '111') -- Regards, Bhavesh Shah On Thu, May 31, 2012 at 12:49 PM, wd wrote: > hi, > > We setup a new hive 0.9 client, Found some sql did not work, for example > > hive> create table t1(a int) partitioned by

Hive partition problem

2012-05-31 Thread wd
hi, We setup a new hive 0.9 client, Found some sql did not work, for example hive> create table t1(a int) partitioned by ( dt int ); OK Time taken: 0.097 seconds hive> load data local inpath '/tmp/t' into table t1 partition (dt=111); Copying data from file:/tmp/t Copying file: file:/tmp/t Loading