hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "vengatesh.babu" <vengatesh.b...@zohocorp.com>
Subject Re: Hive Query o/p to HDFS as CSV file
Date Fri, 09 Jan 2015 13:46:15 GMT
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&lt;vengatesh.babu@zohocorp.com&gt;
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










Mime
View raw message