You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Naveen Gangam (JIRA)" <ji...@apache.org> on 2016/12/06 22:36:59 UTC
[jira] [Commented] (HIVE-15374) Hive column comments
disappearing/being replaced by "from deserializer"
[ 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)