[IMPALA-6305] Allow column definitions in ALTER VIEW

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 2.13.0, Impala 3.1.0
• Component/s: Frontend
• Labels: sql-language
• Epic Color: ghx-label-7
• Assignee: Pooja Nilangekar
• Reporter: Alexander Behm
• Created: 11/Dec/17 20:09
• Updated: 25/Feb/19 07:57
• Resolved: 27/Jun/18 23:00

Description

When working with views we currently only allow separate column definitions in CREATE VIEW but not in ALTER VIEW.

Example:

create table t1 (c1 int, c2 int);
create view v (x comment 'hello world', y) as select * from t1;
describe v;
+------+------+-------------+
| name | type | comment     |
+------+------+-------------+
| x    | int  | hello world |
| y    | int  |             |
+------+------+-------------+

Currently we cannot use ALTER VIEW to change the column definitions after the fact, i.e. the following should be supported:

alter view v (z1, z2 comment 'foo bar') as select * from t1;

Sub-Tasks

• Impala 3.1 Doc: Allow Column Definitions in ALTER VIEW: Closed