[SPARK-44837] Improve error message for ALTER TABLE ALTER COLUMN on partition columns in non-delta tables

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.0.3, 3.1.3, 3.2.4, 3.3.2, 3.4.1, 4.0.0
• Fix Version/s: 4.0.0
• Component/s: SQL
• Labels: pull-request-available
• Assignee: Michael Zhang
• Reporter: Michael Zhang
• Created: 16/Aug/23 22:18
• Updated: 20/Oct/23 05:56
• Resolved: 20/Oct/23 05:56

Description

 

-- hive table
sql("create table some_table (x int, y int, z int) using parquet PARTITIONED BY (x, y) " +
"location '/Users/someone/runtime/tmp-data/some_table'")
sql("alter table some_table alter column x comment 'some-comment'").collect()
Can't find column `x` given table data columns [`z`].

Improve error message to indicate to users that the command is not supported on partition columns in non-delta tables.

 

Issue Links

• links to: GitHub Pull Request #42524