Support Questions
Find answers, ask questions, and share your expertise

How to create excel file from Hive query output?

 
1 ACCEPTED SOLUTION

Accepted Solutions

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

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

View solution in original post

3 REPLIES 3

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

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

View solution in original post

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

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.