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

Switch to Threaded View
Hive, mail # user - Hive Table to CSV file


Copy link to this message
-
Re: Hive Table to CSV file
Raj Hadoop 2013-07-02, 02:14
Sorry. Its my bad.  I see the files now. I was looking in a different directory earlier.
________________________________
 From: Mohammad Tariq <[EMAIL PROTECTED]>
To: user <[EMAIL PROTECTED]>
Sent: Monday, July 1, 2013 8:26 PM
Subject: Re: Hive Table to CSV file
 
Do you have permissions to write to this path?And make sure you are looking into the local FS, as Stephen has specified.
Warm Regards,
Tariq
cloudfront.blogspot.com

On Tue, Jul 2, 2013 at 5:25 AM, Stephen Sprague <[EMAIL PROTECTED]> wrote:

you gotta admit that's kinda funny.  Your stderr output shows not only once but three times where it put the output and in fact how many rows it put there.  and to top it off it reported 'SUCCESS'.
>
>but you're saying there's nothing there?
>
>now. call me crazy but i would tend to believe hive over you - but that's just me. :)
>
>are you looking at the local filesystem on the same box you ran hive?
>
>
>
>
>On Mon, Jul 1, 2013 at 4:01 PM, Raj Hadoop <[EMAIL PROTECTED]> wrote:
>
>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
>>
>>
>>
>>
>