hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raj Hadoop <hadoop...@yahoo.com>
Subject Hive Table to CSV file
Date Mon, 01 Jul 2013 23:01:53 GMT
Hi,

My requirement is to load data from a (one column) Hive view to a CSV file. After loading
it, I dont see any file generated.

I used the following commands to load data to file from a view v_june1


hive > set hive.io.output.fileformat=CSVTextFile;
 hive > insert overwrite local directory '/usr/home/hadoop/da1/' select * from v_june1_pgnum


.....The output at console is like the below..... 



MapReduce Total cumulative CPU time: 4 minutes 15 seconds 590 msec
Ended Job = job_201306141336_0113
Copying data to local directory /usr/home/hadoop/da1
Copying data to local directory /usr/home/hadoop/da1
3281 Rows loaded to /usr/home/hadoop/da1
MapReduce Jobs Launched:
Job 0: Map: 21  Reduce: 6   Cumulative CPU: 255.59 sec   HDFS Read: 5373722496 HDFS Write:
389069 SUCCESS
Total MapReduce CPU Time Spent: 4 minutes 15 seconds 590 msec
OK
Time taken: 148.764 second



My Question : I do not see any files created under /usr/home/hadoop/da1. Where are the files
created?

Thanks,
Raj
Mime
View raw message