[jira] [Comment Edited] (FLINK-14613) Add validation check when applying UDF to tempral table key in Temporal Table Join condition

["hailong wang (Jira)" <ji...@apache.org>]

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

hailong wang edited comment on FLINK-14613 at 11/5/19 11:59 AM:
----------------------------------------------------------------

cc [~jark]. What do you think,  Can I go ahead on it. Thanks


was (Author: hailong wang):
cc [~jark]. What do you think. Can I go ahead on it.

> Add validation check when applying UDF to  tempral table key in  Temporal Table Join condition 
> -----------------------------------------------------------------------------------------------
>
>                 Key: FLINK-14613
>                 URL: https://issues.apache.org/jira/browse/FLINK-14613
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table SQL / Planner
>    Affects Versions: 1.9.1
>            Reporter: hailong wang
>            Priority: Major
>             Fix For: 1.10.0
>
>
> In Temporal Table Join, We don't support using  UDF in tempral table join key. For we can't analyze LookupKeys  when call is an expression. When users use like this, the program run normally,  and the result will be wrong. So we should add validation to prevent it.
> The SQL as following:
> {code:java}
> INSERT INTO A
> SELECT B.amount, B.currency, C.amount, C.product 
> FROM B join C FOR SYSTEM_TIME AS OF B.proctime 
> on B.amount = C.amount and C.product = '1'
> {code}



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