Read XML file in hive

[#1]

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>

[#2]

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