[ https://issues.apache.org/jira/browse/SPARK-33588?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dongjoon Hyun resolved SPARK-33588. ----------------------------------- Fix Version/s: 3.1.0 Assignee: Maxim Gekk Resolution: Fixed This is resolved via https://github.com/apache/spark/pull/30529 > Partition spec in SHOW TABLE EXTENDED doesn't respect > `spark.sql.caseSensitive` > ------------------------------------------------------------------------------- > > Key: SPARK-33588 > URL: https://issues.apache.org/jira/browse/SPARK-33588 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 2.4.8, 3.0.2, 3.1.0 > Reporter: Maxim Gekk > Assignee: Maxim Gekk > Priority: Major > Fix For: 3.1.0 > > > For example: > {code:sql} > 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 TABLE EXTENDED LIKE 'tbl1' PARTITION(YEAR = 2015, Month = 1); > Error in query: Partition spec is invalid. The spec (YEAR, Month) must match > the partition spec (year, month) defined in table '`default`.`tbl1`'; > {code} > The spark.sql.caseSensitive flag is false by default, so, the partition spec > is valid. -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org