[
https://issues.apache.org/jira/browse/IMPALA-6305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16776604#comment-16776604
]
ASF subversion and git services commented on IMPALA-6305:
---------------------------------------------------------
Commit 1219d8fb11358c36284e459e0b9fd37d26f44df9 in impala's branch
refs/heads/2.x from poojanilangekar
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=1219d8f ]
IMPALA-6305: Allow column definitions in ALTER VIEW
This change adds support to change column definitions in ALTER VIEW
statements. This support only required minor changes in the parser
and the AlterViewStmt constructor.
Here's an example syntax:
alter view foo (a, b comment 'helloworld') as
select * from bar;
describe foo;
+------+--------+------------+
| name | type | comment |
+------+--------+------------+
| a | string | |
| b | string | helloworld |
+------+--------+------------+
The following tests were modified:
1. ParserTest - To check that the parser handles column definitions
for alter view statements.
2. AnalyzerDDLTest - To ensure that the analyzer supports the
change column definitions parsed.
3. TestDdlStatements - To verify the end-to-end functioning of
ALTER VIEW statements with change column definitions.
4. AuthorizationTest - To ensure that alter table commands with
column definitions check permissions as expected.
Change-Id: I6073444a814a24d97e80df15fcd39be2812f63fc
Reviewed-on: http://gerrit.cloudera.org:8080/10720
Reviewed-by: Impala Public Jenkins <impala-public-jenk...@cloudera.com>
Tested-by: Impala Public Jenkins <impala-public-jenk...@cloudera.com>
> 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 2.13.0, 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-unsubscr...@impala.apache.org
For additional commands, e-mail: issues-all-h...@impala.apache.org
