Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Hive Table to CSV file

Copy link to this message
Hive Table to CSV file

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
Time taken: 148.764 second

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

Stephen Sprague 2013-07-01, 23:55
Mohammad Tariq 2013-07-02, 00:26
Raj Hadoop 2013-07-02, 02:14