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.

Read XML file in hive

Read XML file in hive

New Contributor

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>

1 REPLY 1
Highlighted

Re: Read XML file in hive

Expert Contributor

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