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

Switch to Threaded View
Hive >> mail # user >> Writing data to LOCAL with Hive Server2


Copy link to this message
-
Re: Writing data to LOCAL with Hive Server2
well that does complicate matters then. :)  how to get a file off a host
you don't have access to? when you say no access i presume you mean you
have no login access.

I can think of some ideas:

   1. make a case to get access so rsync can connect. (best)

   2. can you run a "hdfs dfs -get" command from you client? (next best)

   3. run your query to stdout and redirect that to your file. eg. $ hive
-host foo -port 10000 -e "select foo from bar;" >my_local_file (least
desirable)

the page i was thinking of was this:
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+ImportExport
don't think it helps your situation though.
Let us know how you make out!

Cheers,
Stephen.
On Fri, Mar 14, 2014 at 10:56 AM, Kumar V <[EMAIL PROTECTED]> wrote: