[HIVE-11208] Can not drop a default partition __HIVE_DEFAULT_PARTITION__ which is not a "string" type

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.1.0
• Fix Version/s: 2.3.0
• Component/s: Parser
• Assignee: Aihua Xu
• Reporter: Yongzhi Chen
• Created: 08/Jul/15 14:06
• Updated: 21/Jul/17 17:45
• Resolved: 17/Nov/16 17:02

Description

When partition is not a string type, for example, if it is a int type, when drop the default partition _HIVE_DEFAULT_PARTITION_, you will get:
SemanticException Unexpected unknown partitions
Reproduce:

SET hive.exec.dynamic.partition=true;
SET hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions.pernode=10000;

DROP TABLE IF EXISTS test;
CREATE TABLE test (col1 string) PARTITIONED BY (p1 int) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' STORED AS TEXTFILE;
INSERT OVERWRITE TABLE test PARTITION (p1) SELECT code, IF(salary > 600, 100, null) as p1 FROM jsmall;

hive> SHOW PARTITIONS test;
OK
p1=100
p1=__HIVE_DEFAULT_PARTITION__
Time taken: 0.124 seconds, Fetched: 2 row(s)

hive> ALTER TABLE test DROP partition (p1 = '__HIVE_DEFAULT_PARTITION__');
FAILED: SemanticException Unexpected unknown partitions for (p1 = null)

Issue Links

• breaks: HIVE-15923 Hive default partition causes errors in get partitions
• duplicates: HIVE-11237 Unable to drop a default partition with "int" type