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<vengatesh.b...@zohocorp.com> wrote ---- 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 in local directory. For HDFS: INSERT OVERWRITE DIRECTORY '/home/test/result/' SELECT * from table; output written to the HDFS is serialized as text with columns separated by ^A and rows separated by newlines. (NOTE : ROW FORMAT DELIMITED FIELDS ---- Not supported for above query) Is there any way to write hive query output in HDFS directory as CSV file(comma separated) Thanks Vengatesh Babu K M
