Creating excel extract from hive not working
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.
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.
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.