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 2015/03/20 20:39:38 UTC

[jira] [Commented] (CALCITE-631) JdbcJoin to support Non-EquiJoin

    [ https://issues.apache.org/jira/browse/CALCITE-631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14371940#comment-14371940 ] 

Julian Hyde commented on CALCITE-631:
-------------------------------------

Agree, this would be useful. We might find that some databases can't support all kinds of join (e.g. some do not support FULL join) but we could cross that bridge when we come to it.

> JdbcJoin to support Non-EquiJoin
> --------------------------------
>
>                 Key: CALCITE-631
>                 URL: https://issues.apache.org/jira/browse/CALCITE-631
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Ng Jiunn Jye
>            Assignee: Julian Hyde
>
> Currently, the JdbcJoin only support EquiJoin. ie select * from tab1 inner join tab2 on tab1.col1=tab2.col2
> NonEqui join are not supported in JdbcJoin, thus resulting execution plan which uses EnumerationJoin and EnumerableCalc for joining and not pushing the join down to remote database. 



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