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

Implement theta join, inner and outer, in enumerable convention

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    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

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment