Creating excel extract from hive not working

hi there,

 

I am trying to extract data from hive table to excel using generic dataflow . However, file gets created the name I gave in the dataflow with xlsx extension. But when i try to opening the file with excel then it is throwing the error.

Creating excel extract from hive not working

 

then I changed the extension to xls  and run the dataflow again then also same error.  If you can let me how to extract the data into xlsx file and subsequently it can be open by excel then that would be great.

 

Thanks in advance for assisting me in this matter.

Praveen

Beginner Asked on November 16, 2020 in Diyotta Studio.
Add Comment
1 Answer(s)

Hi Praveen,

Can you try to provide the delimiter as comma (,) and file format as CSV? Try opening the created file using excel it works.

Currently, excel file is supported only as part of the Ingestion only. We are not supporting the excel file format as part of file export.

Expert Answered on November 20, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.