Uploaded image for project: 'Apache AsterixDB'
  1. Apache AsterixDB
  2. ASTERIXDB-1326

Left-outer-join on an external dataset doesn't work

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      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".

        Attachments

          Activity

            People

            • Assignee:
              wangsaeu Taewoo Kim
              Reporter:
              wangsaeu Taewoo Kim
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: