You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2014/11/02 22:54:34 UTC
[jira] [Commented] (CALCITE-451) Implement theta join, inner and
outer, in enumerable convention
[ https://issues.apache.org/jira/browse/CALCITE-451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14194048#comment-14194048 ]
Julian Hyde commented on CALCITE-451:
-------------------------------------
Work in progress in https://github.com/julianhyde/incubator-calcite/tree/calcite-451. Will probably commit after package reorg CALCITE-296 is complete.
> 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)