[ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16451422#comment-16451422 ]
Steve Yeom commented on HIVE-18999: ----------------------------------- Talked with Ashutosh. What he is proposing is that we can convert the type conversion while we are converting Hive filter expression AST tree to Calcite Rex node tree, not during execution, > 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 > Assignee: Steve Yeom > Priority: Major > Attachments: HIVE-18999.01.patch, HIVE-18999.02.patch, > HIVE-18999.03.patch > > > {code:sql} > 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')); > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)