How to create excel file from Hive query output?

[#1 · Accepted solution]

You can use the below command which generates the tsv file:

hive -e 'select * from table' > output.tsv

[#2]

My file should be in the extension of .xslx @Sandeep Nemuri

[#3]

I don't think we have a way to write a .xslx file, However you can write csv or tsv which are compatible with excel.