Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-451

Implement theta join, inner and outer, in enumerable convention

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0.0-incubating
    • Component/s: None
    • Labels:
      None

      Description

      Implement theta join in enumerable convention. It must handle not just equi-, or equi-plus-theta (see CALCITE-371) but any join condition. It must also handle inner and all types of outer join.

      Performance may not be that good. Other join algorithms (e.g. hash join, nested loops doing range scans into a sorted map, or merge joins) can offer better alternatives for particular operators (e.g. BETWEEN).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                julianhyde Julian Hyde
                Reporter:
                julianhyde Julian Hyde
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: