[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gopal V updated HIVE-18999: --------------------------- Description: 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')); was: 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')); > 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 > Priority: Major > > 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)