like above ,if you load a xml file without giving any properties than you would have one line of xml into xmldata string,but actually you should have everything which comes under "Store" tag ,into one line .i.e in xmldata. 

check attached image and change the values accordingly . You may need to add a jar which will have properties to deal with XML. 

I am trying to parse some XML data with the xpath functions in Hive and receiving below error.

What i have done so far:

Sample Data:

<Store>
    <Version>1.1</Version>
    <StoreId>16695</StoreId>    
    <Bskt>
      <TillNo>4</TillNo>
      <BsktNo>1753</BsktNo>
      <DateTime>2017-10-31T11:19:34.000+11:00</DateTime>
      <OpID>50056</OpID>
      <Itm>
        <ItmSeq>1</ItmSeq>
        <GTIN>29559</GTIN>
        <ItmDsc>CHOCALATE</ItmDsc>
      <ItmProm>
          <PromCD>CM</PromCD>
        </ItmProm>
      </Itm>
      <Itm>
        <ItmSeq>2</ItmSeq>
        <GTIN>59653</GTIN>
        <ItmDsc>CORN FLAKES</ItmDsc>
      </Itm>
        <Itm>
        <ItmSeq>3</ItmSeq>
        <GTIN>42260</GTIN>
        <ItmDsc> MILK CHOCOLATE 162GM</ItmDsc>
        <ItmProm>
          <PromCD>MTSRO</PromCD>
          <OfferID>11766</OfferID>
        </ItmProm>
      </Itm>
    </Bskt>
    <Bskt>
      <TillNo>5</TillNo>
      <BsktNo>1947</BsktNo>
      <DateTime>2017-10-31T16:24:59.000+11:00</DateTime>
      <OpID>50063</OpID>
      <Itm>
        <ItmSeq>1</ItmSeq>
        <GTIN>24064</GTIN>
        <ItmDsc>TOMATOES 2KG</ItmDsc>
        <ItmProm>
          <PromCD>INSTORE</PromCD>
        </ItmProm>
      </Itm>
      <Itm>
        <ItmSeq>2</ItmSeq>
        <GTIN>81287</GTIN>
        <ItmDsc>ROTHMANS BLUE</ItmDsc>
        <ItmProm>
          <PromCD>TF</PromCD>
        </ItmProm>
      </Itm>
    </Bskt>
  </Store>  

1) Create an external table to read the entire XML data in a single column.

CREATE EXTERNAL TABLE poc_scanp_xml_single(xmldata STRING) LOCATION '/DEV/TEST/nanda_test';

2) Create a view on top 

CREATE VIEW xmldataview (version,storeid,basket_dtm,basket_num,till_number,item_sequence,gtin_number,item_desc,promo_code,offer_id)
	AS SELECT
	xpath_string(xmldata,'Store/Version/text()'),
	xpath_string(xmldata,'Store/StoreId/text()'),
	xpath_string(xmldata,'Store/Bskt/DateTime/text()'),
	xpath_string(xmldata,'Store/Bskt/BsktNo/text()'),
	xpath_string(xmldata,'Store/Bskt/TillNo/text()'),
	xpath_string(xmldata,'Store/Bskt/Itm/ItmSeq/text()'),
	xpath_string(xmldata,'Store/Bskt/Itm/GTIN/text()'),
	xpath_string(xmldata,'Store/Bskt/Itm/ItmDsc/text()'),
	xpath_string(xmldata,'Store/Bskt/Itm/ItmProm/PromCD/text()'),
	xpath_string(xmldata,'Store/Bskt/Itm/ItmProm/OfferID/text()')
	FROM POC_SRC_IGA_SCAN_BASKET_ITEM_PROMO_SINGLE;

Error while reading the data from view:

Bad status for request TFetchResultsReq(fetchType=0, operationHandle=TOperationHandle(hasResultSet=True, modifiedRowCount=None, operationType=0, operationId=THandleIdentifier(secret='\x8c\x8c\xd4\xa6\xa8\x84F\x14\x80\xbb\x01\xc8$\x85\xaa\x9b', guid='~}\\\xef%\x0eI\x99\xbc\xff\x85p /\xbe5')), orientation=4, maxRows=100): TFetchResultsResp(status=TStatus(errorCode=0, errorMessage='java.io.IOException: org.apache.hadoop.hive.ql.metadata.HiveException: Unable to execute method public org.apache.hadoop.io.Text org.apache.hadoop.hive.ql.udf.xml.UDFXPathString.evaluate(java.lang.String,java.lang.String) on object org.apache.hadoop.hive.ql.udf.xml.UDFXPathString@6dfa6b18 of class org.apache.hadoop.hive.ql.udf.xml.UDFXPathString with arguments { <Store>:java.lang.String, Store/Version/text():java.lang.String} of size 2', sqlState=None, infoMessages=, statusCode=3), results=None, hasMoreRows=None)

I had provided with 31 days of data in flat file (songid,userid,timestamp)

I have to pick Top 100 Trending songs for 25-31 dated which streamed online trending means most frequently played songs

Need to develop amap reduce program for this

Thank You