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. Want to know more about what has changed? Check out the Community News blog.

How to load XML file in hive?

How to load XML file in hive?

Contributor

How to load XML file in hive? Any insights?

2 REPLIES 2

Re: How to load XML file in hive?

Master Guru
There's no inbuilt solution and XML is not an ideal format of choice - I recommend transforming the files into Avro or Parquet.

You can use a 3rd party XML SerDe within Hive however, such as https://github.com/dvasilen/Hive-XML-SerDe.
Highlighted

Re: How to load XML file in hive?

New Contributor
Is it still the case