Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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.


Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.