[ 
https://issues.apache.org/jira/browse/FLINK-22009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17310600#comment-17310600
 ] 

ying zhang commented on FLINK-22009:
------------------------------------

!image-2021-03-29-19-37-30-286.png!

 

 

MAP<STRING, FLOAT>  and union operation has this error too

 

 

> Unsupported type Map<String, String> when union two Hive tables
> ---------------------------------------------------------------
>
>                 Key: FLINK-22009
>                 URL: https://issues.apache.org/jira/browse/FLINK-22009
>             Project: Flink
>          Issue Type: Bug
>          Components: Connectors / Hive
>    Affects Versions: 1.12.0
>            Reporter: ying zhang
>            Priority: Major
>         Attachments: image-2021-03-29-15-45-48-627.png, 
> image-2021-03-29-19-37-30-286.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)

Reply via email to