[
https://issues.apache.org/jira/browse/FLINK-5725?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15929476#comment-15929476
]
Yuhong Hong commented on FLINK-5725:
------------------------------------
In this issue, i mostly want to support join like follow:
{code}
SELECT o.proctime, o.productId, o.orderId, s.proctime AS shipTime
FROM Orders AS o
[LEFT | RIGHT | FULL] [OUTER] JOIN Shipments AS s
ON o.orderId = s.orderId
AND o.proctime BETWEEN s.proctime AND s.proctime + INTERVAL '1' HOUR;
{code}
the design doc:
https://docs.google.com/document/d/17eTqXVnAXm7-QB59WvU2JBsSrycxqLw6EPEwN2eNix8/edit?usp=sharing
> Support JOIN between two streams in the SQL API
> -----------------------------------------------
>
> Key: FLINK-5725
> URL: https://issues.apache.org/jira/browse/FLINK-5725
> Project: Flink
> Issue Type: New Feature
> Components: Table API & SQL
> Reporter: Haohui Mai
> Assignee: Yuhong Hong
>
> As described in the title.
> This jira proposes to support joining two streaming tables in the SQL API.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
