You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Jing Zhang (JIRA)" <ji...@apache.org> on 2019/07/31 10:13:00 UTC
[jira] [Updated] (FLINK-13509) Support `is not distinct from ` and
similar syntax in LookupJoin
[ https://issues.apache.org/jira/browse/FLINK-13509?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jing Zhang updated FLINK-13509:
-------------------------------
Description:
Example1:
{code:java}
`SELECT T.id, T.len, T.content, D.name FROM T JOIN userTable for system_time as of T.proctime AS D ON T.id = D.id OR (T.id is null and D.id is null)`
{code}
Example2:
{code:java}
"SELECT T.id, T.len, T.content, D.name FROM T JOIN userTable for system_time as of T.proctime AS D ON T.id IS NOT DISTINCT FROM D.id"
{code}
Now run the above sql in Blink planner, the results are not expected.Because LookupJoin does not handle the case correctly.
Here is plan:
In 1.9 version, simply throw exception in compile phase for the above sql.
Support the feature in 1.10 version.
was:
Example1:
{code:java}
`SELECT T.id, T.len, T.content, D.name FROM T JOIN userTable for system_time as of T.proctime AS D ON T.id = D.id OR (T.id is null and D.id is null)`
{code}
Example2:
{code:java}
"SELECT T.id, T.len, T.content, D.name FROM T JOIN userTable for system_time as of T.proctime AS D ON T.id IS NOT DISTINCT FROM D.id"
{code}
Now run the above sql in Blink planner, the results are error.Because LookupJoin does not handle the case correctly.
Here is plan:
In 1.9 version, simply throw exception in compile phase for the above sql.
Support the feature in 1.10 version.
> Support `is not distinct from ` and similar syntax in LookupJoin
> ----------------------------------------------------------------
>
> Key: FLINK-13509
> URL: https://issues.apache.org/jira/browse/FLINK-13509
> Project: Flink
> Issue Type: Task
> Components: Table SQL / Planner
> Affects Versions: 1.10.0
> Reporter: Jing Zhang
> Priority: Minor
> Fix For: 1.10.0
>
>
> Example1:
> {code:java}
> `SELECT T.id, T.len, T.content, D.name FROM T JOIN userTable for system_time as of T.proctime AS D ON T.id = D.id OR (T.id is null and D.id is null)`
> {code}
> Example2:
> {code:java}
> "SELECT T.id, T.len, T.content, D.name FROM T JOIN userTable for system_time as of T.proctime AS D ON T.id IS NOT DISTINCT FROM D.id"
> {code}
> Now run the above sql in Blink planner, the results are not expected.Because LookupJoin does not handle the case correctly.
> Here is plan:
> In 1.9 version, simply throw exception in compile phase for the above sql.
> Support the feature in 1.10 version.
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)