[jira] [Updated] (HIVE-12362) Hive's Parquet SerDe ignores 'serialization.null.format' property
[ https://issues.apache.org/jira/browse/HIVE-12362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naveen Gangam updated HIVE-12362: - Attachment: HIVE-12362.2.patch > Hive's Parquet SerDe ignores 'serialization.null.format' property > - > > Key: HIVE-12362 > URL: https://issues.apache.org/jira/browse/HIVE-12362 > Project: Hive > Issue Type: Bug > Components: Hive >Affects Versions: 1.1.0 >Reporter: Naveen Gangam >Assignee: Naveen Gangam > Attachments: HIVE-12362.2.patch, HIVE-12362.patch > > > {code} > create table src (a string); > insert into table src values (NULL), (''), (''); > 0: jdbc:hive2://localhost:1/default> select * from src; > +---+--+ > | src.a | > +---+--+ > | NULL | > || > || > +---+--+ > create table dest (a string) row format serde > 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' stored as > INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat' > OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'; > alter table dest set SERDEPROPERTIES ('serialization.null.format' = ''); > alter table dest set TBLPROPERTIES ('serialization.null.format' = ''); > insert overwrite table dest select * from src; > 0: jdbc:hive2://localhost:1/default> select * from test11; > +---+--+ > | test11.a | > +---+--+ > | NULL | > || > || > +---+--+ > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Updated] (HIVE-12362) Hive's Parquet SerDe ignores 'serialization.null.format' property
[ https://issues.apache.org/jira/browse/HIVE-12362?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Naveen Gangam updated HIVE-12362: - Attachment: HIVE-12362.patch Attaching a patch for review. Please review and provide feedback. > Hive's Parquet SerDe ignores 'serialization.null.format' property > - > > Key: HIVE-12362 > URL: https://issues.apache.org/jira/browse/HIVE-12362 > Project: Hive > Issue Type: Bug > Components: Hive >Affects Versions: 1.1.0 >Reporter: Naveen Gangam >Assignee: Naveen Gangam > Attachments: HIVE-12362.patch > > > {code} > create table src (a string); > insert into table src values (NULL), (''), (''); > 0: jdbc:hive2://localhost:1/default> select * from src; > +---+--+ > | src.a | > +---+--+ > | NULL | > || > || > +---+--+ > create table dest (a string) row format serde > 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' stored as > INPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat' > OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'; > alter table dest set SERDEPROPERTIES ('serialization.null.format' = ''); > alter table dest set TBLPROPERTIES ('serialization.null.format' = ''); > insert overwrite table dest select * from src; > 0: jdbc:hive2://localhost:1/default> select * from test11; > +---+--+ > | test11.a | > +---+--+ > | NULL | > || > || > +---+--+ > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)