[jira] [Created] (HIVE-18999) Filter operator does not work for List

["Steve Yeom (JIRA)" <ji...@apache.org>]

Steve Yeom created HIVE-18999:
---------------------------------

             Summary: Filter operator does not work for List
                 Key: HIVE-18999
                 URL: https://issues.apache.org/jira/browse/HIVE-18999
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
    Affects Versions: 3.0.0
            Reporter: Steve Yeom


The repro is from EAR-8093 , especially by [~jcamachorodriguez]. 
I have reproduced at the current master.
set hive.optimize.point.lookup=false;
  
create table table1(col0 int, col1 bigint, col2 string, col3 bigint, col4 bigint);

insert into table1 values (1, 10000, 'ccl',2014, 11);
insert into table1 values (1, 10000, 'ccl',2015, 11);
insert into table1 values (1, 10000, 'ccl',2014, 11);
insert into table1 values (1, 10000, 'ccl',2013, 11);

-- INCORRECT
SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in (struct(2014,11));
-- CORRECT
SELECT COUNT(t1.col0) from table1 t1 where struct(col3, col4) in (struct('2014','11'));





--
This message was sent by Atlassian JIRA
(v7.6.3#76005)