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

[#1]

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?

[#2 · Accepted solution]

@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'='')