Hi,
We are storing our final transformed data in Hive table in JSON format. while
storing data into table, all the null fields are converted into \\N. while
reading table, we are seeing \\N instead of NULL. We tried setting
ALTER TABLE sample set SERDEPROPERTIES ('serialization.null.format' = "\N");
ALTER TABLE sample set TBLPROPERTIES ('serialization.null.format' = "\N");
But it didn't work, is there any better approach which out any reloading of
data into table.
We cannot use regexp_replace for 100 columns of table while querying data.
