Aihua Xu created HIVE-11237:
-------------------------------
Summary: Unable to drop a default partition with "int" type
Key: HIVE-11237
URL: https://issues.apache.org/jira/browse/HIVE-11237
Project: Hive
Issue Type: Bug
Components: Query Processor
Affects Versions: 2.0.0
Reporter: Aihua Xu
Assignee: Aihua Xu
{noformat}
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 > 60000, 100,
null) as p1 FROM default.sample_07;
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)
{noformat}
The default partition name '__HIVE_DEFAULT_PARTITION__' cannot be deleted.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
