[IMPALA-3413] Can't add default partition to external table

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Information Provided
• Affects Version/s: Impala 2.0
• Fix Version/s: Impala 2.6.0
• Component/s: Backend
• Labels: s3
• Target Version: Impala 2.6.0
• Assignee: Unassigned
• Reporter: Mostafa Mokhtar
• Created: 22/Apr/16 23:08
• Updated: 22/Apr/16 23:40
• Resolved: 22/Apr/16 23:40

Description

Data loading with dynamic partitioning creates a default partition named "_HIVE_DEFAULT_PARTITION_" for NULL values.
When issuing an "ADD PARTITION" command it fails because Impala expects a value of the same type as the partition column, this also messes up the metadata.

ALTER TABLE tpcds_1000_parquet.store_sales ADD PARTITION(ss_sold_date_sk=__HIVE_DEFAULT_PARTITION__);

https://github.com/apache/hive/blob/master/common/src/java/org/apache/hadoop/hive/conf/HiveConf.java#L447