[jira] [Updated] (HIVE-24080) CBO failed: Array and Map are not support when convert calcite types to hive types

[Jira]

     [ 
https://issues.apache.org/jira/browse/HIVE-24080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

范宜臻 updated HIVE-24080:
-----------------------
    Description: 
```sql

drop table temp.test_cbo_fyz_right;
CREATE EXTERNAL TABLE temp.test_cbo_right(
 `rid` string,
 `dtm` string,
 `map` map<string, string>,
 `tags` array <string>
);

drop table temp.test_cbo_fyz_left;
CREATE EXTERNAL TABLE temp.test_cbo_left(
 `lid` string,
 `dtm` string
)


explain select
b.tags
from temp.test_cbo_left a
left join temp.test_cbo_right b on a.lid = b.rid
where b.dtm = '20200814'
and a.dtm = '20200813'

```

> CBO failed: Array and Map are not support when convert calcite types to hive 
> types
> ----------------------------------------------------------------------------------
>
>                 Key: HIVE-24080
>                 URL: https://issues.apache.org/jira/browse/HIVE-24080
>             Project: Hive
>          Issue Type: Bug
>          Components: CBO, Logical Optimizer
>    Affects Versions: 3.0.0, 2.3.4
>            Reporter: 范宜臻
>            Priority: Critical
>
> ```sql
> drop table temp.test_cbo_fyz_right;
> CREATE EXTERNAL TABLE temp.test_cbo_right(
>  `rid` string,
>  `dtm` string,
>  `map` map<string, string>,
>  `tags` array <string>
> );
> drop table temp.test_cbo_fyz_left;
> CREATE EXTERNAL TABLE temp.test_cbo_left(
>  `lid` string,
>  `dtm` string
> )
> explain select
> b.tags
> from temp.test_cbo_left a
> left join temp.test_cbo_right b on a.lid = b.rid
> where b.dtm = '20200814'
> and a.dtm = '20200813'
> ```



--
This message was sent by Atlassian Jira
(v8.3.4#803005)