Reply
New Contributor
Posts: 1
Registered: ‎11-27-2017

Read XML file in hive

Need help in reading this xml file in hive

 

<?xml version="1.0" encoding="UTF-8"?>
<appointments>
<appointment>
<Field name="Route Date">2017-11-21</Field>
<Field name="Route ID">102</Field>
<Field name="Activity ID">1287</Field>
<Field name="Master Activity ID" />
<Field name="Activity Type">regular</Field>
<Field name="Work Type">5</Field>
<Field name="Activity Status">cancelled</Field>
<Field name="Work Order">OSS360_SO_A0364796</Field>
<Field name="Start" />
<Field name="Duration">0</Field></appointment>
</appointments>

Highlighted
Cloudera Employee
Posts: 31
Registered: ‎11-16-2015

Re: Read XML file in hive

A similar query was asked a while back. Please see here for more details and the workarounds.

 

Announcements