CODEWITHSUNDEEP
hadoophiveopencsv
Chi.che
Chi.che

Reputation: 33

Hive table always set column comment is "from deserializer"

I execute query to create Hive table below:

CREATE TABLE db1.test_create_tbl( column1 smallint COMMENT 'desc of column')
COMMENT 'desc of table'
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.OpenCSVSerde' 
STORED AS TEXTFILE

I execute query to display table schema below:

DESCRIBE db1.test_create_tbl

But when i get table schema, column description always display "from deserializer"

Please touch me, thanks

Upvotes: 0

Views: 3967

Answers (1)

JagadeeshK
JagadeeshK

Reputation: 47

I have come across same issue. I have changed the hive configuration and it worked fine.

set the below parameter in hive shell.

set hive.serdes.using.metastore.for.schema=org.apache.hadoop.hive.serde2.OpenCSVSerde;

Upvotes: 2

Related Questions