[jira] [Created] (IMPALA-6305) Allow column definitions in ALTER VIEW

["Alexander Behm (JIRA)" <ji...@apache.org>]

Alexander Behm created IMPALA-6305:
--------------------------------------

             Summary: Allow column definitions in ALTER VIEW
                 Key: IMPALA-6305
                 URL: https://issues.apache.org/jira/browse/IMPALA-6305
             Project: IMPALA
          Issue Type: Improvement
          Components: Frontend
            Reporter: Alexander Behm


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

Example:
{code}
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  |             |
+------+------+-------------+
{code}

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

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




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)