[jira] [Comment Edited] (HIVE-14385) Show create table does not display comments

["Chetna Chaudhari (JIRA)" <ji...@apache.org>]

    [ 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)