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:11:15 UTC
[jira] [Created] (PIG-3172) Partition filter push down does not
happen when there is a non partition key filter
Rohini Palaniswamy created PIG-3172:
---------------------------------------
Summary: Partition filter push down does not happen when there is a non partition key filter
Key: PIG-3172
URL: https://issues.apache.org/jira/browse/PIG-3172
Project: Pig
Issue Type: Bug
Affects Versions: 0.10.1
Reporter: Rohini Palaniswamy
A = LOAD 'job_confs' USING org.apache.hcatalog.pig.HCatLoader();
B = FILTER A by grid == 'cluster1' and dt < '2012_12_01' and dt > '2012_11_20';
C = FILTER B by params#'mapreduce.job.user.name' == 'userx';
D = FOREACH B generate dt, grid, params#'mapreduce.job.user.name' as user,
params#'mapreduce.job.name' as job_name, job_id,
params#'mapreduce.job.cache.files';
dump D;
The query gives the below warning and ends up scanning the whole table instead of pushing the partition key filters grid and dt.
[main] WARN org.apache.pig.newplan.PColFilterExtractor - No partition filter
push down: Internal error while processing any partition filter conditions in
the filter after the load
--
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