Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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.