Support Questions

Find answers, ask questions, and share your expertise

Best way to create Hive table from XML file

avatar
Expert Contributor

Hi. What is - in your opinion - the best way to import XML file into Hive table?

Is there any way to import XML file to Hive directly? My currently idea is: import XML to Oracle table, and then import Oracle table to Hive using Sqoop. Do you have better idea?

1 ACCEPTED SOLUTION

avatar
Master Guru
3 REPLIES 3

avatar
Master Guru

avatar
Explorer

You can automate the whole process of generating ORC/Parquet for Hive in a relational structure. This blog post shows how to convert MISMO XML to Hive and Parquet

,

You can automate the whole process of generating ORC/Parquet for Hive in a relational structure. This blog post shows how to convert MISMO XML to Hive and Parquet

avatar
Contributor

Try this NIFI groovy processor it converts XML files to CSV or AVRO

https://github.com/maxbback/nifi-xml