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

        Issue Links

          Activity

          Hide
          julianhyde Julian Hyde added a comment -

          Work in progress in https://github.com/julianhyde/incubator-calcite/tree/calcite-451. Will probably commit after package reorg CALCITE-296 is complete.

          Show
          julianhyde Julian Hyde added a comment - Work in progress in https://github.com/julianhyde/incubator-calcite/tree/calcite-451 . Will probably commit after package reorg CALCITE-296 is complete.
          Show
          julianhyde Julian Hyde added a comment - Fixed in http://git-wip-us.apache.org/repos/asf/incubator-calcite/commit/167623f4 .
          Hide
          julianhyde Julian Hyde added a comment -

          Closing now that 1.0.0-incubating has been released.

          Show
          julianhyde Julian Hyde added a comment - Closing now that 1.0.0-incubating has been released.

            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:

                Development