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