Support Questions

Find answers, ask questions, and share your expertise

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

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

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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.