ying zhang created FLINK-22009:
----------------------------------
Summary: when data type is map,we cannot union
Key: FLINK-22009
URL: https://issues.apache.org/jira/browse/FLINK-22009
Project: Flink
Issue Type: Bug
Affects Versions: 1.12.0
Reporter: ying zhang
Attachments: image-2021-03-29-15-45-48-627.png
I create 2 tables which contains data type map,but i flind i cannot union two
tables，is there any solutions to solve this problem？
!image-2021-03-29-15-45-48-627.png!
this is the create table statements：
CREATE TABLE `map_string_string1`(
`query` string,
`wid` string,
`index` int,
`page` string,
`hc_cid1` string,
`hc_cid2` string,
`hc_cid3` string,
`cid1` string,
`cid2` string,
`cid3` string,
`ts` bigint,
`number_feature` map<string,string>)
PARTITIONED BY (
`dt` string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
STORED AS INPUTFORMAT
'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
CREATE TABLE `map_string_string2`(
`query` string,
`wid` string,
`index` int,
`page` string,
`hc_cid1` string,
`hc_cid2` string,
`hc_cid3` string,
`cid1` string,
`cid2` string,
`cid3` string,
`ts` bigint,
`number_feature` map<string,string>)
PARTITIONED BY (
`dt` string)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
STORED AS INPUTFORMAT
'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
OUTPUTFORMAT
'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
