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

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-18999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16406624#comment-16406624 ] 

Jesus Camacho Rodriguez commented on HIVE-18999:
------------------------------------------------

[~steveyeom2017], is this a duplicate of HIVE-18610? Or does it still exist in master?

Cc [~gopalv]

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