Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

OpenCSV serde in hive gives " ( double quotes) when field is empty

Solved Go to solution

OpenCSV serde in hive gives " ( double quotes) when field is empty

Expert Contributor

I have mapped CSV to hive .

In case my CSV has nothing for value i.e is an empty string for a column value, hive shows column value as

"

So, in this case, I can not check if the value is NULL,because for hive, value is " .

if I see CSV in a text editor, I can see that the value there is

""""

double quotes with in double quotes. Is there a way I can fix it?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: OpenCSV serde in hive gives " ( double quotes) when field is empty

Mentor
@Simran Kaur

you should set tblproperties on your table to treat blanks as NULL https://community.hortonworks.com/questions/21001/i-have-few-column-to-make-external-table-in-hive-f...

TBLPROPERTIES ('serialization.null.format'='')
1 REPLY 1

Re: OpenCSV serde in hive gives " ( double quotes) when field is empty

Mentor
@Simran Kaur

you should set tblproperties on your table to treat blanks as NULL https://community.hortonworks.com/questions/21001/i-have-few-column-to-make-external-table-in-hive-f...

TBLPROPERTIES ('serialization.null.format'='')