Thanks for your reply.
I want to know how to update those comments.
> 在 2019年9月20日,00:22,Suresh Kumar Sethuramaswamy <[email protected]> 写道:
>
> 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 黄璞 <[email protected]
> <mailto:[email protected]> 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!
>