[jira] [Created] (CALCITE-451) Implement theta join, inner and outer, in enumerable convention

["Julian Hyde (JIRA)" <ji...@apache.org>]

Julian Hyde created CALCITE-451:
-----------------------------------

             Summary: Implement theta join, inner and outer, in enumerable convention
                 Key: CALCITE-451
                 URL: https://issues.apache.org/jira/browse/CALCITE-451
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)