You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-zh@flink.apache.org by yidan zhao <hi...@gmail.com> on 2021/10/27 08:45:15 UTC
flinksql写hive的时候，数据类型不匹配。
Flink SQL> insert into upd_sh.dr1 select cast('cid' as string) as cid,
cast(2001 as bigint) as server_time, cast('20211027' as string) as dt,
cast('01' as str
ing) as `hour`, cast('7102' as string) as supply_id, cast(map['sid','7102',
'subid', 'i am a subid'] as map<string,string>) as d;
[INFO] Submitting SQL update statement to the cluster...
[ERROR] Could not execute SQL statement. Reason:
org.apache.flink.table.api.ValidationException: Column types of query
result and sink for registered table 'hive.upd_sh.dr1' do not match.
Cause: Incompatible types for sink column 'd' at position 2.
Query schema: [cid: STRING NOT NULL, server_time: BIGINT NOT NULL, dt:
STRING NOT NULL, hour: STRING NOT NULL, supply_id: STRING NOT NULL, d:
MAP<STRING, STRING> NOT NULL]
Sink schema: [cid: STRING, server_time: BIGINT, d: MAP<STRING, STRING>,
dt: STRING, hour: STRING, supply_id: STRING]
如上，显示是d这个字段有问题，但实际上d我已经强制转换了，类型完全一致。
Re: flinksql写hive的时候，数据类型不匹配。
Posted by Caizhi Weng <ts...@gmail.com>.
Hi！
是字段的顺序不一致（sink schema 里 d 在第三个，query 里 d 在最后）。需要将这两个顺序调整到一致。
yidan zhao <hi...@gmail.com> 于2021年10月27日周三 下午4:45写道：
> Flink SQL> insert into upd_sh.dr1 select cast('cid' as string) as cid,
> cast(2001 as bigint) as server_time, cast('20211027' as string) as dt,
> cast('01' as str
> ing) as `hour`, cast('7102' as string) as supply_id, cast(map['sid','7102',
> 'subid', 'i am a subid'] as map<string,string>) as d;
> [INFO] Submitting SQL update statement to the cluster...
> [ERROR] Could not execute SQL statement. Reason:
> org.apache.flink.table.api.ValidationException: Column types of query
> result and sink for registered table 'hive.upd_sh.dr1' do not match.
> Cause: Incompatible types for sink column 'd' at position 2.
>
> Query schema: [cid: STRING NOT NULL, server_time: BIGINT NOT NULL, dt:
> STRING NOT NULL, hour: STRING NOT NULL, supply_id: STRING NOT NULL, d:
> MAP<STRING, STRING> NOT NULL]
> Sink schema: [cid: STRING, server_time: BIGINT, d: MAP<STRING, STRING>,
> dt: STRING, hour: STRING, supply_id: STRING]
>
>
> 如上，显示是d这个字段有问题，但实际上d我已经强制转换了，类型完全一致。
>