You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Dawid Wysakowicz (Jira)" <ji...@apache.org> on 2020/01/20 10:41:00 UTC
[jira] [Created] (FLINK-15686) SELECT 'ABC'; does not work in
sql-client
Dawid Wysakowicz created FLINK-15686:
----------------------------------------
Summary: SELECT 'ABC'; does not work in sql-client
Key: FLINK-15686
URL: https://issues.apache.org/jira/browse/FLINK-15686
Project: Flink
Issue Type: Bug
Components: Table SQL / Client
Affects Versions: 1.10.0
Reporter: Dawid Wysakowicz
Assignee: Dawid Wysakowicz
Fix For: 1.10.0
A query like {{SELECT 'abc';}} fails in sql-client with blink planner enabled with an error:
{code}
org.apache.flink.table.api.ValidationException: Type CHAR(3) of table field 'EXPR$0' does not match with the physical type STRING of the 'EXPR$0' field of the TableSink consumed type.
{code}
The reason is that those sinks do not properly support new type system. There is no good way to define schema and consumed data type so that they match. We should update the in-memory sinks in sql-client to work with the legacy type system for now until the retract and upsert sinks work properly with the new type system.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)