[CALCITE-631] Push theta joins down to JDBC adapter

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0-incubating
• Assignee: Julian Hyde
• Reporter: Ng Jiunn Jye
• Created: 19/Mar/15 03:41
• Updated: 16/Apr/15 08:35
• Resolved: 01/Apr/15 20:08

Description

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.