You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Alexander Behm (JIRA)" <ji...@apache.org> on 2017/11/22 05:25:00 UTC

[jira] [Created] (IMPALA-6233) Document the column definitions list in CREATE VIEW

Alexander Behm created IMPALA-6233:
--------------------------------------

             Summary: Document the column definitions list in CREATE VIEW
                 Key: IMPALA-6233
                 URL: https://issues.apache.org/jira/browse/IMPALA-6233
             Project: IMPALA
          Issue Type: Improvement
          Components: Docs
    Affects Versions: Impala 2.10.0
            Reporter: Alexander Behm
            Assignee: John Russell


Looking at this page:
https://www.cloudera.com/documentation/enterprise/latest/topics/impala_create_view.html#create_view

It appears we do not have an example for the "columns_list" that shows adding a comment to a column. We should add that.

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}



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