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 <saigr...@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 > > >