You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Daniel Dai (Resolved) (JIRA)" <ji...@apache.org> on 2012/03/01 09:00:12 UTC
[jira] [Resolved] (PIG-2535) Bug in new logical plan results in no
output for join
[ https://issues.apache.org/jira/browse/PIG-2535?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Daniel Dai resolved PIG-2535.
-----------------------------
Resolution: Fixed
Fix Version/s: 0.11
0.9.3
0.10
Assignee: Daniel Dai
Hadoop Flags: Reviewed
Unit test pass. test-patch:
[exec] -1 overall.
[exec]
[exec] +1 @author. The patch does not contain any @author tags.
[exec]
[exec] +1 tests included. The patch appears to include 3 new or modified tests.
[exec]
[exec] -1 javadoc. The javadoc tool appears to have generated 1 warning messages.
[exec]
[exec] +1 javac. The applied patch does not increase the total number of javac compiler warnings.
[exec]
[exec] +1 findbugs. The patch does not introduce any new Findbugs warnings.
[exec]
[exec] -1 release audit. The applied patch generated 533 release audit warnings (more than the trunk's current 530 warnings).
javadoc and release audit warning is unrelated.
Patch committed to 0.9/0.10/trunk.
> Bug in new logical plan results in no output for join
> -----------------------------------------------------
>
> Key: PIG-2535
> URL: https://issues.apache.org/jira/browse/PIG-2535
> Project: Pig
> Issue Type: Bug
> Affects Versions: 0.8.1, 0.9.1, 0.10
> Reporter: Vivek Padmanabhan
> Assignee: Daniel Dai
> Fix For: 0.10, 0.9.3, 0.11
>
> Attachments: PIG-2535-0.patch, PIG-2535-1.patch, PIG-2535-2.patch
>
>
> The below script is a snippet of a much larger script. The join in the script results in 0 output for Pig 0.8,0.9 and 0.10 though there are matching records.
> {code}
> event_serve = LOAD 'input1' USING MyMapLoader() AS (s:map[], m:map[], l:map[]);
> raw = LOAD 'input2' USING MyMapLoader() AS (s:map[], m:map[], l:map[]);
> SPLIT raw INTO
> serve_raw IF (( (chararray) (s#'type') == '0') AND ( (chararray) (s#'source') == '5')),
> cm_click_raw IF (( (chararray) (s#'type') == '1') AND ( (chararray) (s#'source') == '5'));
> cm_serve = FOREACH serve_raw GENERATE s#'cm_serve_id' AS cm_event_guid, s#'cm_serve_timestamp_ms' AS cm_receive_time, s#'p_url' AS ctx ;
> cm_serve_lowercase = stream cm_serve through `tr [:upper:] [:lower:]`;
> cm_serve_final = FOREACH cm_serve_lowercase GENERATE $0 AS cm_event_guid, $1 AS cm_receive_time, $2 AS ctx;
> filtered = FILTER event_serve BY (chararray) (s#'filter_key') neq 'xxxx' AND (chararray) (s#'filter_key') neq 'yyyy';
> event_serve_project = FOREACH filtered GENERATE s#'event_guid' AS event_guid, s#'receive_time' AS receive_time;
> event_serve_join = join cm_serve_final by (cm_event_guid, cm_receive_time), event_serve_project by (event_guid, receive_time) PARALLEL 800;
> STORE event_serve_join INTO 'output' ;
> {code}
> The script produces correct results if I disable ColumnMapKeyPrune optimizer.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira