You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Rohini Palaniswamy (JIRA)" <ji...@apache.org> on 2013/02/08 17:17:14 UTC

[jira] [Created] (PIG-3173) Partition filter push down does not happen partition keys condition include a AND and OR construct

Rohini Palaniswamy created PIG-3173:
---------------------------------------

             Summary: Partition filter push down does not happen partition keys condition include a AND and OR construct
                 Key: PIG-3173
                 URL: https://issues.apache.org/jira/browse/PIG-3173
             Project: Pig
          Issue Type: Bug
            Reporter: Rohini Palaniswamy
            Assignee: Rohini Palaniswamy


A = load 'db.table' using org.apache.hcatalog.pig.HCatLoader();
B = filter A by (region=='usa' AND dt=='201302051800') OR (region=='uk' AND dt=='201302051800');
C = foreach B generate name, age;
DUMP C;

gives the below warning and scans the whole table.

2013-02-06 22:22:16,233 [main] WARN  org.apache.pig.newplan.PColFilterExtractor  - No partition filter push down: You have an partition column (region ) in a construction like: (pcond  and ...) or (pcond and ...) where pcond is a condition on a partition column.
2013-02-06 22:22:16,233 [main] WARN  org.apache.pig.newplan.PColFilterExtractor  - No partition filter push down: You have an partition column (datestamp ) in a construction like: (pcond  and ...) or (pcond and ...) where pcond is a condition on a partition column.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira