hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-18999) Filter operator does not work for List
Date Fri, 06 Apr 2018 17:28:00 GMT

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

Ashutosh Chauhan commented on HIVE-18999:
-----------------------------------------

Although this fixes the issue, its not an ideal solution. e.g., this fix doesn't address vectorization
case. So, this will still be an issue on vectorized path.

Compiler should generate type safe plan and runtime shouldn't be responsible for 'fixing'
up type mismatch. So, correct fix is to insert these casts in TypeCheckProcFactory when we
generate ExprNodeDesc from AST.

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

Mime
View raw message