[
https://issues.apache.org/jira/browse/FLINK-26460?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
tartarus updated FLINK-26460:
-----------------------------
Description:
{code:java}
CREATE TABLE zm_test (
`a` BIGINT,
`m` MAP<STRING,BIGINT>
);
{code}
if we insert into zm_test use
{code:java}
INSERT INTO zm_test(`a`) SELECT `a` FROM MyTable;
{code}
then will throw Exception
{code:java}
Unsupported type when convertTypeToSpec: MAP
{code}
we must use
{code:java}
INSERT INTO zm_test SELECT `a`, cast(null AS MAP<STRING,BIGINT>) FROM MyTable;
{code}
was:
{code:java}
CREATE TABLE zm_test (
`a` BIGINT,
`m` MAP<STRING,BIGINT>
);
{code}
if we insert into zm_test use
{code:java}
INSERT INTO appendSink(`a`) SELECT `a` FROM MyTable;
{code}
then will throw Exception
{code:java}
Unsupported type when convertTypeToSpec: MAP
{code}
we must use
{code:java}
INSERT INTO appendSink SELECT `a`, cast(null AS MAP<STRING,BIGINT>) FROM
MyTable;
{code}
> Fix Unsupported type when convertTypeToSpec: MAP
> ------------------------------------------------
>
> Key: FLINK-26460
> URL: https://issues.apache.org/jira/browse/FLINK-26460
> Project: Flink
> Issue Type: Bug
> Components: Table SQL / Planner
> Affects Versions: 1.13.1, 1.15.0
> Reporter: tartarus
> Assignee: tartarus
> Priority: Major
> Labels: pull-request-available
>
> {code:java}
> CREATE TABLE zm_test (
> `a` BIGINT,
> `m` MAP<STRING,BIGINT>
> );
> {code}
> if we insert into zm_test use
> {code:java}
> INSERT INTO zm_test(`a`) SELECT `a` FROM MyTable;
> {code}
> then will throw Exception
> {code:java}
> Unsupported type when convertTypeToSpec: MAP
> {code}
> we must use
> {code:java}
> INSERT INTO zm_test SELECT `a`, cast(null AS MAP<STRING,BIGINT>) FROM MyTable;
> {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
