[jira] [Comment Edited] (FLINK-14173) ANSI-style JOIN with Temporal Table Function fails

["Benoît Paris (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FLINK-14173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16936597#comment-16936597 ] 

Benoît Paris edited comment on FLINK-14173 at 9/24/19 9:25 AM:
---------------------------------------------------------------

Hi [~jark]!

I was so sure I used the ANSI-style, I guess my memory is playing tricks on me. Out of curiosity, what are these different semantics?

Thanks to you guys for all the work on Flink!

Cheers


was (Author: benoitparis):
Hi [~jark]!

I was so sure I used the ANSI-style, I guess my memory is playing trick on me. Out of curiosity, what are these different semantics?

Thanks to you guys for all the work on Flink!

Cheers

> ANSI-style JOIN with Temporal Table Function fails
> --------------------------------------------------
>
>                 Key: FLINK-14173
>                 URL: https://issues.apache.org/jira/browse/FLINK-14173
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / Legacy Planner, Table SQL / Planner
>    Affects Versions: 1.9.0
>         Environment: Java 1.8, Scala 2.11, Flink 1.9 (pom.xml file attached)
>            Reporter: Benoît Paris
>            Priority: Major
>         Attachments: flink-test-temporal-tables-1.9.zip
>
>
> The planner fails to generate a plan for ANSI-style joins with Temporal Table Functions. The Blink planners throws with a "Missing conversion is LogicalTableFunctionScan[convention: NONE -> LOGICAL]" message (and some very fancy graphviz stuff). The old planner does a "This exception indicates that the query uses an unsupported SQL feature."
> This fails:
> {code:java}
>  SELECT 
>    o_amount * r_amount AS amount 
>  FROM Orders 
>  JOIN LATERAL TABLE (Rates(o_proctime)) 
>    ON r_currency = o_currency {code}
> This works:
> {code:java}
>  SELECT 
>    o_amount * r_amount AS amount 
>  FROM Orders 
>     , LATERAL TABLE (Rates(o_proctime)) 
>  WHERE r_currency = o_currency{code}
> Reproduction with the attached Java and pom.xml files. Also included: stack traces for both Blink and the old planner.
> I think this is a regression. I remember using ANSI-style joins with a temporal table function successfully in 1.8.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)