[HIVE-3069] Drop partition problem

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.9.0
• Fix Version/s: 0.10.0
• Component/s: SQL

Environment

hive 0.9 bin, and postgres as metadata.

• Assignee: Unassigned
• Reporter: wd
• Created: 31/May/12 09:36
• Updated: 10/Jan/13 19:53
• Resolved: 01/Jun/12 13:34

Description

Setup a new hive 0.9 client, follow this steps

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'

after change partition column type to string, it's worked.