Hello,

I find that when to load data into table using 
'org.apache.hadoop.hive.serde2.OpenCSVSerde’, the field’s comment of table
will be 'from deserializer’. How can I get rid of this comment or customize the 
comment.

The procedure to produce the problem:
1. Create a table use the hive create SQL, such as:
create table `db`.`table`(
   `field1` string,
   `field2` string,
   `field3` string
) row format serde 'org.apache.hadoop.hive.serde2.OpenCSVSerde';

2. Load csv file use the hive load data SQL, such as:
load data local inpath 'my/file/path' overwrite into table `db`.`table`;

3. The table schema will be:
field1                  string                  from deserializer
field2                  string                  from deserializer
field3                  string                  from deserializer

Noticed that the comment of every field will be 'from deserializer'.


Thanks!

Reply via email to