You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Rockey Cui (Jira)" <ji...@apache.org> on 2019/12/12 03:29:00 UTC
[jira] [Commented] (FLINK-15155) Join with a LookupableTableSource:
the defined order lookup keys are inconsistent
[ https://issues.apache.org/jira/browse/FLINK-15155?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16994139#comment-16994139 ]
Rockey Cui commented on FLINK-15155:
------------------------------------
Sorry, I misunderstood defined order.
I thought it was the order after the join on condition, but in fact it was the order when registering the LookupableTableSource
> Join with a LookupableTableSource: the defined order lookup keys are inconsistent
> ----------------------------------------------------------------------------------
>
> Key: FLINK-15155
> URL: https://issues.apache.org/jira/browse/FLINK-15155
> Project: Flink
> Issue Type: Bug
> Components: API / DataStream
> Affects Versions: 1.9.1
> Environment: win10_x64
> idea2019.2.4_x64
> jdk1.8.0_211_x64
> Reporter: Rockey Cui
> Priority: Major
> Attachments: getAsyncLookupFunction.png
>
>
> My DQL==>
> SELECT
> D1.S_INT ,
> D1.S_LONG ,
> D1.S_NUMBER1 ,
> D1.S_ADDRESS ,
> D1.S_DATE_EVENT ,
> D1.S_TIMESTAMP_EVENT
> FROM
> CIRROSTREAM_DIM_GHL_SOURCE_131111_CSL AS F1 LEFT JOIN CIRROSTREAM_DIM_GHL_DIM_131111 FOR SYSTEM_TIME AS OF F1.PROCTIME AS D1
> ON {color:#FF0000}F1.S_INT = D1.S_INT{color}
> {color:#FF0000} AND F1.S_LONG = D1.S_LONG{color}
> {color:#FF0000} AND F1.S_NUMBER1 = D1.S_NUMBER1{color}
> {color:#FF0000} AND F1.S_ADDRESS = D1.S_ADDRESS{color}
> WHERE
> F1.S_INT BETWEEN 1501 AND 2000
> ----
> My LookupableTableSource.getAsyncLookupFunction received lookupKeys==>
> 0 = "S_ADDRESS"
> 1 = "S_INT"
> 2 = "S_LONG"
> 3 = "S_NUMBER1"
> ----
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)