You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Mona Chitnis (JIRA)" <ji...@apache.org> on 2014/02/25 19:18:20 UTC

[jira] [Commented] (PIG-3594) Pig with HCatLoader partition filter does not push down valid conditions

    [ https://issues.apache.org/jira/browse/PIG-3594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13911825#comment-13911825 ] 

Mona Chitnis commented on PIG-3594:
-----------------------------------

Thanks [~aniket486], from what I remember, I needed this fix for 0.11 branch and 0.12 was ok. But will check once again to confirm.

> Pig with HCatLoader partition filter does not push down valid conditions
> ------------------------------------------------------------------------
>
>                 Key: PIG-3594
>                 URL: https://issues.apache.org/jira/browse/PIG-3594
>             Project: Pig
>          Issue Type: Bug
>    Affects Versions: 0.11.1
>            Reporter: Mona Chitnis
>             Fix For: 0.11.2
>
>
>  When running the following pig query (script.pig) :
> A = LOAD ' my_data' USING org.apache.hcatalog.pig.HCatLoader();
> B = FILTER A by part1=='$val1' and part2 matches '$val2';
> C = FILTER  B by map#'key' matches '(val3|val4)';
> DUMP C;
> > pig -useHCatalog -p val1=2013_01_01 val2=XYZ script.pig
> This results in Pig scanning all partitions inspite of filter condition. part1=='$val1' should have been pushed to HCatLoader even though there are other conditions that cannot be pushed.



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)