[SPARK-28054] Unable to insert partitioned table dynamically when partition name is upper case

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4.3
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: L. C. Hsieh
• Reporter: ChenKai
• Created: 14/Jun/19 08:45
• Updated: 12/Dec/22 18:11
• Resolved: 24/Jun/19 00:45

Description

-- create sql and column name is upper case
CREATE TABLE src (KEY STRING, VALUE STRING) PARTITIONED BY (DS STRING)

-- insert sql
INSERT INTO TABLE src PARTITION(ds) SELECT 'k' key, 'v' value, '1' ds

The error is:

Error in query: org.apache.hadoop.hive.ql.metadata.Table.ValidationFailureSemanticException: Partition spec {ds=, DS=1} contains non-partition columns;

Issue Links

• links to: GitHub Pull Request #24886
• links to: GitHub Pull Request #24971
• links to: GitHub Pull Request #25234