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]*来自志愿者整理的flink邮件归档