Re: Hive Query o/p to HDFS as CSV file

A workaround might be to create an external table with the correct format, insert overwrite into the external table, then drop the external table (which I think shouldn't delete the directory) On Jan 9, 2015, at 5:46 AM, vengatesh.babu wrote: > Hi, > > How to write Hive query output to HDFS

Re: Hive Query o/p to HDFS as CSV file

Hi, How to write Hive query output to HDFS directory as CSV file(comma separated). Thanks Vengatesh Babu K M On Wed, 07 Jan 2015 11:46:39 +0530 vengatesh.babu wrote Hi, I want to write hive query output into HDFS file in CSV Format( comma separate

Hive Query o/p to HDFS as CSV file

Hi, I want to write hive query output into HDFS file in CSV Format( comma separated). For LOCAL DIRECTORY: INSERT OVERWRITE LOCAL DIRECTORY '/home/test/result/' ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' SELECT * from table; Above Works fine and writes output of query as CSV Format i