You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Zha Ji (Jira)" <ji...@apache.org> on 2022/06/20 11:29:00 UTC
[jira] [Created] (FLINK-28132) Should we remove type validations when using lookup-key join ?
Zha Ji created FLINK-28132:
------------------------------
Summary: Should we remove type validations when using lookup-key join ?
Key: FLINK-28132
URL: https://issues.apache.org/jira/browse/FLINK-28132
Project: Flink
Issue Type: Improvement
Components: Connectors / JDBC, Table SQL / Planner
Affects Versions: 1.15.0
Reporter: Zha Ji
As described in https://issues.apache.org/jira/browse/FLINK-18234
Execute sql
{color:#6a8759}select * from t left join jdbc_source for system_time as of t.proctime AS j on t.id = j.id{color}
t.id(VARCHAR) j.id(INT) will throw exception
org.apache.flink.table.api.TableException: VARCHAR(2147483647) and INTEGER does not have common type now
If I remove some type validation codes, the sql works well on MySQL
Is it necessary to check data types when we join stream data to dynamic tables
--
This message was sent by Atlassian Jira
(v8.20.7#820007)