Loading xml to hive and fetching unbounded tags

[harish tangella]

Hi,

  Request you to help.

  Fetching unbounded tags from the xml in hive

 We tried with xpath but unable to get all the unbounded tags.

a sample xml file is

<Rows>
<Row>
<APPLICATION_ID>1</APPLICATION_ID>
<AppDetails>
<AppDetail>
<APPLICATION_CODE>1</APPLICATION_CODE>
</AppDetail>
<AppDetail>
<APPLICATION_CODE>2</APPLICATION_CODE>
</AppDetail>
</AppDetails>
</Row>
</Rows>

we are able to get the application code by giving [1] in appdetail. Request
for help to get all the appdetail tags.