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