You are concerned about data dictionary getting overwritten?
Or do you want to know how to update those comments( from deserializer)? Regards Suresh Kumar Sethuramaswamy On Wed, Sep 18, 2019, 11:46 PM 黄璞 <huangpu.b...@bytedance.com wrote: > 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! > >
