[
https://issues.apache.org/jira/browse/CALCITE-631?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14388763#comment-14388763
]
Ng Jiunn Jye commented on CALCITE-631:
--------------------------------------
I have added 9 test cases to run in JDBC data source.
The test suite did not run any slower. Below are the reactor summary before and
after the patch
#############
Before Patch
#############
[INFO] Reactor Summary:
[INFO]
[INFO] Calcite ............................................ SUCCESS [ 7.558 s]
[INFO] Calcite Avatica .................................... SUCCESS [ 6.597 s]
[INFO] Calcite Avatica Server ............................. SUCCESS [ 0.676 s]
[INFO] Calcite Linq4j ..................................... SUCCESS [ 2.818 s]
[INFO] Calcite Core ....................................... SUCCESS [02:38 min]
[INFO] Calcite Examples ................................... SUCCESS [ 0.299 s]
[INFO] Calcite Example CSV ................................ SUCCESS [ 5.874 s]
[INFO] Calcite MongoDB .................................... SUCCESS [ 1.890 s]
[INFO] Calcite Plus ....................................... SUCCESS [ 2.306 s]
[INFO] Calcite Spark ...................................... SUCCESS [ 1.891 s]
[INFO] Calcite Splunk ..................................... SUCCESS [ 1.490 s]
[INFO] Calcite Ubenchmark ................................. SUCCESS [ 0.801 s]
[INFO] ------------------------------------------------------------------------
#############
After Patch
#############
[INFO] Reactor Summary:
[INFO]
[INFO] Calcite ............................................ SUCCESS [ 3.440 s]
[INFO] Calcite Avatica .................................... SUCCESS [ 3.758 s]
[INFO] Calcite Avatica Server ............................. SUCCESS [ 0.490 s]
[INFO] Calcite Linq4j ..................................... SUCCESS [ 2.305 s]
[INFO] Calcite Core ....................................... SUCCESS [02:02 min]
[INFO] Calcite Examples ................................... SUCCESS [ 0.455 s]
[INFO] Calcite Example CSV ................................ SUCCESS [ 5.302 s]
[INFO] Calcite MongoDB .................................... SUCCESS [ 1.854 s]
[INFO] Calcite Plus ....................................... SUCCESS [ 2.574 s]
[INFO] Calcite Spark ...................................... SUCCESS [ 7.792 s]
[INFO] Calcite Splunk ..................................... SUCCESS [ 1.559 s]
[INFO] Calcite Ubenchmark ................................. SUCCESS [ 1.099 s]
> Push theta joins down to JDBC adapter
> -------------------------------------
>
> Key: CALCITE-631
> URL: https://issues.apache.org/jira/browse/CALCITE-631
> Project: Calcite
> Issue Type: Improvement
> Reporter: Ng Jiunn Jye
> Assignee: Julian Hyde
> Fix For: next
>
> Attachments: [CALCITE-631]-PushThetaJoinsDownToJDBCAdapter.patch,
> [CALCITE-631]JdbcJoinToSupportNonEquiJoin.2.patch,
> [CALCITE-631]JdbcJoinToSupportNonEquiJoin.patch
>
>
> 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)
