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?