You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@datafu.apache.org by "Eyal Allweil (JIRA)" <ji...@apache.org> on 2018/11/28 11:07:01 UTC

[jira] [Updated] (DATAFU-130) Add left outer join macro described in the DataFu guide

     [ https://issues.apache.org/jira/browse/DATAFU-130?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eyal Allweil updated DATAFU-130:
--------------------------------
    Attachment: DATAFU-130.patch

> Add left outer join macro described in the DataFu guide
> -------------------------------------------------------
>
>                 Key: DATAFU-130
>                 URL: https://issues.apache.org/jira/browse/DATAFU-130
>             Project: DataFu
>          Issue Type: New Feature
>            Reporter: Eyal Allweil
>            Assignee: Eyal Allweil
>            Priority: Major
>              Labels: macro, newbie
>         Attachments: DATAFU-130.patch
>
>
> In our [guide|http://datafu.incubator.apache.org/blog/2013/09/04/datafu-1-0.html], a macro is described for making a three-way left outer join conveniently. We can add this macro to DataFu to make it even easier to use.
> The macro's code is as follows:
> {noformat}
> DEFINE left_outer_join(relation1, key1, relation2, key2, relation3, key3) returns joined {
>   cogrouped = COGROUP $relation1 BY $key1, $relation2 BY $key2, $relation3 BY $key3;
>   $joined = FOREACH cogrouped GENERATE
>     FLATTEN($relation1),
>     FLATTEN(EmptyBagToNullFields($relation2)),
>     FLATTEN(EmptyBagToNullFields($relation3));
> }
> {noformat}
> (we would obviously want to add a test for this, too)



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)