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

["Pooja Nilangekar (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-6305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pooja Nilangekar resolved IMPALA-6305.
--------------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 3.1.0

> 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
>            Assignee: Pooja Nilangekar
>            Priority: Major
>              Labels: sql-language
>             Fix For: Impala 3.1.0
>
>
> 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
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org