[
https://issues.apache.org/jira/browse/HIVE-14385?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15529638#comment-15529638
]
Chetna Chaudhari edited comment on HIVE-14385 at 9/28/16 1:41 PM:
------------------------------------------------------------------
Verified the issue, issue occurs only if we use show create table to see view
definition. Show create table works fine for tables, but for views it skips
comments.
[~pvary]: You can see comments using
{code}describe extended escape_comments_view1;{code}
I'll check it further, if its expected behavior or a bug. Behavior is
consistent on 1.2.1 and master branch.
was (Author: chetna):
Verified the issue, issue occurs only if we use show create table to see view
definition. Show create table works fine for tables, but for views it skips
comments.
[~pvary]: You can see comments using
{code}describe extended escape_comments_view1;{code}
I'll check it further, if its by expected behavior or a bug.
> Show create table does not display comments
> -------------------------------------------
>
> Key: HIVE-14385
> URL: https://issues.apache.org/jira/browse/HIVE-14385
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2
> Affects Versions: 2.2.0
> Reporter: Peter Vary
>
> Create a view like this:
> {noformat}
> create table escape_comments_tbl1 (col1 string);
> create view escape_comments_view1 (col1 comment 'ab') comment 'abc' as select
> col1 from escape_comments_tbl1;
> {noformat}
> Then run describe table, and the result does not contain the comments:
> {noformat}
> show create table escape_comments_view1;
> CREATE VIEW `escape_comments_view1` AS SELECT `col1` AS `col1` FROM (select
> `escape_comments_tbl1`.`col1` from `default`.`escape_comments_tbl1`)
> `default.escape_comments_view1`
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
