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 <aniket...@gmail.com> 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 <w...@wdicc.com> 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, May 31, 2012 at 3:26 PM, Bhavesh Shah <bhavesh25s...@gmail.com> >> wrote: >> > 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 <bhavesh25s...@gmail.com> >> > 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 31, 2012 at 12:49 PM, wd <w...@wdicc.com> 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 ( 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 data to table default.t1 partition (dt=111) >> >>> OK >> >>> Time taken: 0.375 seconds >> >>> hive> show partitions t1; >> >>> OK >> >>> dt=111 >> >>> Time taken: 0.108 seconds >> >>> hive> alter table t1 drop partition ( dt=111 ); >> >>> FAILED: Error in semantic analysis: Partition not found dt = 111 >> >>> hive> alter table t1 drop partition ( dt='111' ); >> >>> FAILED: Error in semantic analysis: Partition not found dt = '111' >> >>> >> >>> >> >>> So, how to delete the partition? >> >> >> >> >> >> >> >> >> >> >> > >> > >> > >> > -- >> > Regards, >> > Bhavesh Shah >> > > > > > > -- > "...:::Aniket:::... Quetzalco@tl"
