Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> How Can I store the Hive query result in one file ?


Copy link to this message
-
Re: How Can I store the Hive query result in one file ?
will hive -e "query" > filename  or hive -f query.q > filename will do ?

you specially want it to write into a named file on hdfs only?
On Thu, Jul 4, 2013 at 3:12 PM, Matouk IFTISSEN
<[EMAIL PROTECTED]>wrote:

> Hello Hive users,
> Is there a manner to store the Hive  query result (SELECT *.....) in a
> specfique and alone file (given the file name) like (INSERT OVERWRITE LOCAL
> DIRECTORY '/directory_path_name/')?
> Thanks for your answers
>
>
--
Nitin Pawar
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB