You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Vivek Padmanabhan (JIRA)" <ji...@apache.org> on 2011/06/22 20:31:47 UTC

[jira] [Resolved] (PIG-2135) Pig 0.9 ignoring Multiple filter conditions joined with AND/OR

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

Vivek Padmanabhan resolved PIG-2135.
------------------------------------

    Resolution: Invalid

> Pig 0.9 ignoring Multiple filter conditions joined with AND/OR 
> ---------------------------------------------------------------
>
>                 Key: PIG-2135
>                 URL: https://issues.apache.org/jira/browse/PIG-2135
>             Project: Pig
>          Issue Type: Bug
>    Affects Versions: 0.9.0
>            Reporter: Vivek Padmanabhan
>            Assignee: Thejas M Nair
>            Priority: Critical
>             Fix For: 0.9.0
>
>
> When I have multiple filter statements joined by AND/OR , except for the first condition all other conditions are ignored.
> For example in the below script the second condition (org.udfs.Func09('e',w) == 1) is ignored ;
> a = load 'sample_input' using PigStorage(',')  as (q:chararray,w:chararray);
> b = filter a by org.udfs.Func09('f1',q) == 1  AND  org.udfs.Func09('e',w) == 1 ;
> dump b;
> Output from the script
> (f1,a)
> (f1,e)  --> this record should have been filtered by the second condition
> Input for the script;
> f1,a
> f2,b
> f3,c
> f1,e
> f2,f
> f5,e
> The explain of the alias b shows that the second condition is not included in the plan itself.
> The above statements works fine with Pig 0.8.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira