Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Best way to create Hive table from XML file

Solved Go to solution

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

Accepted Solutions

Re: Best way to create Hive table from XML file

3 REPLIES 3

Re: Best way to create Hive table from XML file

Re: Best way to create Hive table from XML file

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

Re: Best way to create Hive table from XML file

New Contributor

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

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