hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kumar V <>
Subject Re: Writing data to LOCAL with Hive Server2
Date Fri, 14 Mar 2014 17:56:53 GMT
Thanks Stephen.
Yes, rsync would be easy.  But we don't have access to the servers the hiveserver2 is running
on.  Basically, there is no way to reach those files from our boxes. That's why I was asking
about writing it locally.  
I'll check this list for import/export like you mentioned.


On Friday, March 14, 2014 12:23 PM, Stephen Sprague <> wrote:
re: HiveServer2

this is not natively possible (this falls under the export rubric.) similarly, you can't load
a file directly from your client using native syntax (import.)

Believe me, you're not the only one who'd like this both of these functions. :)

I'd search this list for import or export utilities as i remember not long ago someone pointed
to page in the doc about these.

as an alternative i just employ rsync to push or pull the file to where i ultimately need
it.  its one line of code which is about as easy as it gets. 

On Fri, Mar 14, 2014 at 5:43 AM, Kumar V <> wrote:

>   Is it possible to write data to a local file system using Hive server 2 ? 
>When I use 'insert overwrite local directory /tmp/hivedata ...............', it writes
data in the directory on the box on which hive server 2 is running. 
>What can I do to write this data to the file system of the box I am running this Java/Python
program from ?
>Other option was to write this data in HDFS.  But I would like to like to  write to
local file if I can.
>Please let me know if it is possible. 
View raw message