Stamatis Zampetakis created HIVE-24886:
------------------------------------------

             Summary: Support simple equality operations between MAP 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


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.




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

Reply via email to