Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
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

avatar
Master 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'='')

View solution in original post

1 REPLY 1

avatar
Master 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'='')