Reply
New Contributor
Posts: 2
Registered: ‎02-18-2016

How to load XML file in hive?

How to load XML file in hive? Any insights?

Posts: 1,695
Kudos: 341
Solutions: 264
Registered: ‎07-31-2013

Re: How to load XML file in hive?

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.
Announcements