[SPARK-33667] Respect case sensitivity in V1 SHOW PARTITIONS

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4.7, 3.0.1, 3.1.0
• Fix Version/s: 2.4.8, 3.0.2, 3.1.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 05/Dec/20 07:08
• Updated: 25/Feb/21 15:18
• Resolved: 06/Dec/20 10:57

Description

SHOW PARTITIONS is case sensitive, and doesn't respect the SQL config spark.sql.caseSensitive which is false by default, for instance:

spark-sql> CREATE TABLE tbl1 (price int, qty int, year int, month int)
         > USING parquet
         > PARTITIONED BY (year, month);
spark-sql> INSERT INTO tbl1 PARTITION(year = 2015, month = 1) SELECT 1, 1;
spark-sql> SHOW PARTITIONS tbl1 PARTITION(YEAR = 2015, Month = 1);
Error in query: Non-partitioning column(s) [YEAR, Month] are specified for SHOW PARTITIONS;

 

Issue Links

• is cloned by: SPARK-34543 Respect case sensitivity in V1 ALTER TABLE .. SET LOCATION
• links to: [Github] Pull Request #30615 (MaxGekk)
• links to: [Github] Pull Request #30615 (MaxGekk)
• links to: [Github] Pull Request #30626 (MaxGekk)
• links to: [Github] Pull Request #30626 (MaxGekk)
• links to: [Github] Pull Request #30627 (MaxGekk)