hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Knowledge gatherer <knowledge.gatherer....@gmail.com>
Subject Re: Loading xml to hive and fetching unbounded tags
Date Fri, 13 Jun 2014 10:31:00 GMT
Are you trying to capture this data in one column and use XPATH with UDF to
get the data.


On Wed, Jun 11, 2014 at 11:12 AM, harish tangella <harish.tangella@gmail.com
> wrote:

> 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.
>

Mime
View raw message