hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Naveen Gangam (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15374) Hive column comments disappearing/being replaced by "from deserializer"
Date Tue, 06 Dec 2016 22:36:59 GMT

    [ https://issues.apache.org/jira/browse/HIVE-15374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15726942#comment-15726942
] 

Naveen Gangam commented on HIVE-15374:
--------------------------------------

The output for the following commands for the table above
{code}
hive> show create table test;
OK
CREATE TABLE `test`(
  `stringid` string COMMENT 'from deserializer', 
  `value` string COMMENT 'from deserializer')
ROW FORMAT SERDE 
  'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' 
WITH SERDEPROPERTIES ( 
  'input.regex'='(.\n{1}\n\n)') 
STORED AS INPUTFORMAT 
  'org.apache.hadoop.mapred.TextInputFormat' 
OUTPUTFORMAT 
  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
LOCATION
  'file:/tmp/warehouse/test'
TBLPROPERTIES (
  'transient_lastDdlTime'='1481063482')
Time taken: 0.289 seconds, Fetched: 15 row(s)
hive> describe test;
OK
stringid            	string              	from deserializer   
value               	string              	from deserializer   
Time taken: 0.095 seconds, Fetched: 2 row(s)
hive> 
{code}


> Hive column comments disappearing/being replaced by "from deserializer"
> -----------------------------------------------------------------------
>
>                 Key: HIVE-15374
>                 URL: https://issues.apache.org/jira/browse/HIVE-15374
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 2.0.0
>            Reporter: Naveen Gangam
>            Assignee: Naveen Gangam
>
> After creating a table in hive with column comments, running show create table or describe
[formatted], on the same table gives "from deserializer" instead of the original comments.

> CREATE TABLE `test`(
>   `stringid` string COMMENT 'string id', 
>   `value` string COMMENT 'description')
> ROW FORMAT SERDE 
>   'org.apache.hadoop.hive.contrib.serde2.RegexSerDe' 
> WITH SERDEPROPERTIES ( 
>   'input.regex'='(.{1})');
> The comments appear to be stored correctly in the HMS backend DB. Just the fetching of
this metadata seems to be incorrect.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message