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

how to load xlsx files into hive table

how to load xlsx files into hive table

Explorer

Hi All,

Got few dozens of xlsx files need to load into hive tables. Each of the xlsx file has its own structure and even worse some of them have multiple spreadsheets which need to load each spreadsheet into different hive table.

Unfortunately, I don't have the luxury of having an ETL tool like Talend, NiFi to facilitate the loading.

 

My question is that so far I yet to find a straight-forward approach of converting xlsx files into hive tables. Appreciate if you can share your experience in converting/parsing xlsx files into hive tables!

 

Thanks