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 Plain View
Hive >> mail # user >> Re: hive to excel


+
Sai Sai 2013-03-04, 08:56
Copy link to this message
-
Re: hive to excel
Hi,

$hive -e 'select * from myTable' > MyResultsFile.txt

Then you can use this file to import into excel

If you want to use HUE , then it has functionality to export to excel
directly.

Thanks,

Jagat Singh

On Mon, Mar 4, 2013 at 7:56 PM, Sai Sai <[EMAIL PROTECTED]> wrote:

> Just wondering how to save the data of a query to excel file.
> For ex:
>  After running the query:
> Select * from myTable;
> we would like to save the query results to xls file.
> Any help is appreciated.
> Thanks
> Sai
>
>
>
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