[SPARK-29633] Make COLUMN optional in ALTER TABLE

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Takeshi Yamamuro
• Created: 29/Oct/19 06:35
• Updated: 29/Oct/19 06:35

Description

In the mater, the query below fails;

create table tt3 (ax bigint, b short, c decimal) using parquet;
alter table tt3 rename c to d;

In PostgreSQL, we can make COLUMN optional;

ALTER TABLE [ IF EXISTS ] [ ONLY ] name [ * ]
    RENAME [ COLUMN ] column_name TO new_column_name

https://www.postgresql.org/docs/current/sql-altertable.html