Home | About | Sematext search-lucene.com search-hadoop.com
 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
Jagat Singh 2013-03-04, 08:58
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
>
>
>