Support Questions

Find answers, ask questions, and share your expertise

Best way to create Hive table from XML file

Rising Star

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

3 REPLIES 3

New Contributor

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

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

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.