Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-2015

Add support for nested loop joins

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: Impala 2.2
    • Fix Version/s: Impala 2.3.0
    • Component/s: None
    • Labels:

      Description

      Add support for nested loop joins in Impala. Primarily used in conjunction with nested types and in cases where non-equity join predicates are used with certain join types.

      Example query that is currently not supported and could be executed when nested loop join is implemented:

      select * from functional.alltypestiny t1 left outer join functional.alltypessmall t2 on t1.int_col < t2.int_col;
      

      Also, in the context of nested types the following query could be executed using a nested loop join:

      select * from customer c left outer join c.orders;
      

        Attachments

          Activity

            People

            • Assignee:
              dtsirogiannis Dimitris Tsirogiannis
              Reporter:
              dtsirogiannis Dimitris Tsirogiannis
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: