pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vivek Padmanabhan (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PIG-2535) Bug in new logical plan results in no output for join
Date Mon, 20 Feb 2012 15:29:34 GMT

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

Vivek Padmanabhan commented on PIG-2535:
----------------------------------------

Hi Daniel, the script goes through fine with the patch after applying output schema for 
| cm_serve_lowercase = stream cm_serve through `tr [:upper:] [:lower:]`;
                
> 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
>         Attachments: PIG-2535-0.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

        

Mime
View raw message