hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From 范宜臻 (Jira) <j...@apache.org>
Subject [jira] [Updated] (HIVE-24080) CBO failed: Array and Map are not support when convert calcite types to hive types
Date Thu, 27 Aug 2020 09:18:00 GMT

     [ 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)

Mime
View raw message