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

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

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
>

This should help.

https://cwiki.apache.org/Hive/languagemanual-dml.html#LanguageManualDML-Wri
tingdataintofilesystemfromqueries
On 3/29/12 4:48 PM, "Paul Ingles" <[EMAIL PROTECTED]> wrote:

>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