[jira] [Resolved] (ASTERIXDB-1326) Left-outer-join on an external dataset doesn't work

["Taewoo Kim (JIRA)" <ji...@apache.org>]

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

Taewoo Kim resolved ASTERIXDB-1326.
-----------------------------------
    Resolution: Fixed

> Left-outer-join on an external dataset doesn't work
> ---------------------------------------------------
>
>                 Key: ASTERIXDB-1326
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1326
>             Project: Apache AsterixDB
>          Issue Type: Bug
>            Reporter: Taewoo Kim
>            Assignee: Taewoo Kim
>
> Left-outer-join on an external dataset generates empty results. For left-outer-join, retainInput and retainNull are all set to true. When retainInput is set to true, in the inner branch, what LookupAdapter does is that propagating all input variables except RIDs (two variables) and additionally generate a record (when there is a matching) or a null (when there is no matching). However, since the logical unnest-map operator does not filter RID information, the Record Descriptor keeps the RID information. Thus, the next operator expects "all input variables including RID + lookupAdapter output variable." However, what LookupAdapter generates is "all input variables - RID + lookupAdapter output". 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)