hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raj Hadoop <hadoop...@yahoo.com>
Subject Re: Hive Table to CSV file
Date Tue, 02 Jul 2013 02:14:30 GMT
Sorry. Its my bad.  I see the files now. I was looking in a different directory earlier.




________________________________
 From: Mohammad Tariq <dontariq@gmail.com>
To: user <user@hive.apache.org> 
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 <spragues@gmail.com> 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 <hadoopraj@yahoo.com> 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
>>
>>
>>
>>
>
Mime
View raw message