Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to create excel file from Hive query output?

Solved Go to solution

How to create excel file from Hive query output?

 
1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to create excel file from Hive query output?

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

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

Re: How to create excel file from Hive query output?

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

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

Re: How to create excel file from Hive query output?

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

Re: How to create excel file from Hive query output?

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.

Don't have an account?
Coming from Hortonworks? Activate your account here