Brilliant, thank you!
On 29 Mar 2012, at 12:23, Bejoy Ks <[email protected]> wrote: > 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 >
