Support Questions

Find answers, ask questions, and share your expertise

Read XML file in hive

New Contributor

Need help in reading this xml file in hive


<?xml version="1.0" encoding="UTF-8"?>
<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>


Expert Contributor

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