hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Jain <ashish....@gmail.com>
Subject Enclosing string values within quotes while writing table to local directory
Date Wed, 04 Jun 2014 21:08:22 GMT
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

Mime
View raw message