$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
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.