Support Questions
Find answers, ask questions, and share your expertise
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"?>
<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>


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.


Don't have an account?
Coming from Hortonworks? Activate your account here