Hello, I'm trying to export a hive table to a local csv file. I'm using the insert overwrite local directory command as follows - insert overwrite local directory './dirr' row format delimited fields terminated by ',' escaped by '"' select * from table_xyz where field1 != '';
I want to enclose string values in double quotes in the file so that any commas in string fields can be escaped. How can I enclose string values within quotes? Thanks Ashish
