You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Sai Sai <sa...@yahoo.in> on 2013/03/04 09:56:09 UTC

Re: hive to excel

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

Re: hive to excel

Posted by Jagat Singh <ja...@gmail.com>.

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 <sa...@yahoo.in> 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
>
>
>