Hi Paul
I guess you are looking out for this,
INSERT OVERWRITE DIRECTORY 'hive query'
https://cwiki.apache.org/Hive/gettingstarted.html#GettingStarted-SQLOperations
Regards
Bejoy
________________________________
From: Paul Ingles <[email protected]>
To: [email protected]
Sent: Thursday, March 29, 2012 4:48 PM
Subject: Executing query and storing output on HDFS
Hi,
I'd like to be able to execute a Hive query and for the output to be stored in
a path on HDFS (rather than immediately returned by the client). Ultimately I'd
like to be able to do this to integrate some of our Hive statements and
Cascading flows.
Does anyone know if this is possible? I could have sworn it was but can't find
any mention of some OUTPUT TO clause on the Hive Wiki.
Many thanks,
Paul
