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? >
