You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@flink.apache.org by "ying zhang (Jira)" <ji...@apache.org> on 2021/03/29 07:47:00 UTC

[jira] [Created] (FLINK-22009) when data type is map,we cannot union

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)