[IMPALA-6233] Document the column definitions list in CREATE VIEW

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.10.0
• Fix Version/s: Impala 2.13.0, Impala 3.1.0
• Component/s: Docs
• Epic Color: ghx-label-8
• Assignee: Alexandra Rodoni
• Reporter: Alexander Behm
• Created: 22/Nov/17 05:24
• Updated: 14/May/18 22:12
• Resolved: 14/May/18 22:12

Description

Looking at this page:
https://impala.apache.org/docs/build/html/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:

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  |             |
+------+------+-------------+