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
