[CALCITE-968] Support stream joins

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.6.0
• Component/s: stream
• Assignee: Julian Hyde
• Reporter: Milinda Pathirage
• Created: 14/Nov/15 22:36
• Updated: 21/Jan/16 22:20
• Resolved: 08/Dec/15 00:40

Description

Stream joins are used to relate information from different streams or stream and relation combinations. Calcite lacks (proper) support for stream-to-relation joins and stream-to-stream joins.

stream-to-relation join like below fails at the SQL validation stage.

select stream orders.orderId, orders.productId, products.name from orders join products on orders.productId = products.id

But if 'products' is a stream, the query is valid according to Calcite, even though the stream-to-stream join in above query is not valid due to unbounded nature of streams.

Issue Links

• depends upon: CALCITE-990 In Volcano, populate RelOptRuleCall.nodeInputs for operands of type "any"
• links to: PR 172