[jira] [Resolved] (PIG-4938) [PiggyBank] XPath returns empty values when using aggregation method

["Daniel Dai (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PIG-4938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Daniel Dai resolved PIG-4938.
-----------------------------
       Resolution: Fixed
     Hadoop Flags: Reviewed
    Fix Version/s: 0.17.0

+1.

Patch committed to trunk. Thanks Nandor!

> [PiggyBank] XPath returns empty values when using aggregation method
> --------------------------------------------------------------------
>
>                 Key: PIG-4938
>                 URL: https://issues.apache.org/jira/browse/PIG-4938
>             Project: Pig
>          Issue Type: Bug
>          Components: piggybank
>    Affects Versions: 0.15.0
>            Reporter: Ivo Lenting
>            Assignee: Nandor Kollar
>            Priority: Minor
>             Fix For: 0.17.0
>
>         Attachments: PIG-4938.patch
>
>
> I have a xml file which I want to parse using the piggybank XPath udf.
> The xml is:
> <Aa name="test1">	
> 	<Bb Cc="1"/>
> 	<Bb Cc="1"/>
> 	<Bb Cc="1"/>
> 	<Bb Cc="1"/>
> 	<Dd>test2</Dd>
> </Aa>
> The xpath contains a sum aggregate to sum all Cc values. 
> The complete pig script:
> REGISTER piggybank.jar
> DEFINE XPath org.apache.pig.piggybank.evaluation.xml.XPath();
> DEFINE XPathAll org.apache.pig.piggybank.evaluation.xml.XPathAll();
> XMLFile = LOAD '/demo/test.xml' using org.apache.pig.piggybank.storage.XMLLoader('Aa') as (xmlContents:chararray);
> MyOutput = FOREACH XMLFile GENERATE XPathAll(xmlContents,'Aa/@name',true,false).$0 AS Aa:chararray,XPath(xmlContents,'sum(Aa/Bb/@Cc)') AS Cc:Double, XPath(xmlContents,'Aa/Dd') AS Dd:chararray;
> STORE MyOutput INTO 'Output/MyOutput' USING PigStorage('|');
> MyOutput:
> test1||test2
> So i'm missing the aggregate 4 in column 2.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)