how to load xlsx files into hive table

[#1]

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