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/09 12:34:00 UTC

[jira] [Created] (FLINK-15155) Join with a LookupableTableSource: the defined order lookup keys are inconsistent

Rockey Cui created FLINK-15155:
----------------------------------

             Summary: 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
         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)