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

simran_k — Thu, 01 Sep 2016 13:45:42 GMT

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?

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

aervits — Mon, 12 Sep 2016 05:44:07 GMT

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