[HIVE-18999] Filter operator does not work for List

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: Query Processor
• Assignee: Steve Yeom
• Reporter: Steve Yeom
• Created: 20/Mar/18 16:25
• Updated: 27/Feb/24 22:24

Description

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'));