[
https://issues.apache.org/jira/browse/HIVE-24886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Stamatis Zampetakis updated HIVE-24886:
---------------------------------------
Description:
Currently equality operations between non primitive data types (MAP, LIST,
STRUCT) work in some very limited cases e.g:
{code:sql}
create table table_map_types (id int, c1 map<int,int>, c2 map<int,int>);
select id from table_map_types where map(1,1) IN (map(1,1), map(1,2),
map(1,3));
{code}
but this feature was never introduced explicitly (zero tests & JIRAs around the
subject) and the vast majority of queries involving comparisons between non
primitive data types now fail at compile time.
The goal of this issue is to support simple equality operations:
* EQUALS(=)
* NOT_EQUALS(<>),
* IN,
* IS DISTINCT FROM,
* IS NOT DISTINCT FROM
between MAP data types when the compared (MAP) types are identical.
was:
Currently equality operations between MAP data types work in some very limited
cases e.g:
{code:sql}
create table table_map_types (id int, c1 map<int,int>, c2 map<int,int>);
select id from table_map_types where map(1,1) IN (map(1,1), map(1,2),
map(1,3));
{code}
but this feature was never introduced explicitly (zero tests & JIRAs around the
subject) and the vast majority of queries involving comparisons between MAP
types now fail at compile time.
The goal of this issue is to support simple equality operations:
* EQUALS(=)
* NOT_EQUALS(<>),
* IN,
* IS DISTINCT FROM,
* IS NOT DISTINCT FROM
between MAP data types when the compared (MAP) types are identical.
> Support simple equality operations between MAP/LIST/STRUCT data types
> ---------------------------------------------------------------------
>
> Key: HIVE-24886
> URL: https://issues.apache.org/jira/browse/HIVE-24886
> Project: Hive
> Issue Type: New Feature
> Components: Query Planning, Query Processor
> Reporter: Stamatis Zampetakis
> Assignee: Stamatis Zampetakis
> Priority: Major
> Labels: pull-request-available
> Time Spent: 10m
> Remaining Estimate: 0h
>
> Currently equality operations between non primitive data types (MAP, LIST,
> STRUCT) work in some very limited cases e.g:
> {code:sql}
> create table table_map_types (id int, c1 map<int,int>, c2 map<int,int>);
> select id from table_map_types where map(1,1) IN (map(1,1), map(1,2),
> map(1,3));
> {code}
> but this feature was never introduced explicitly (zero tests & JIRAs around
> the subject) and the vast majority of queries involving comparisons between
> non primitive data types now fail at compile time.
> The goal of this issue is to support simple equality operations:
> * EQUALS(=)
> * NOT_EQUALS(<>),
> * IN,
> * IS DISTINCT FROM,
> * IS NOT DISTINCT FROM
> between MAP data types when the compared (MAP) types are identical.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
