hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Teruyoshi Zenmyo (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15040) LATERAL VIEW + WHERE IN ...= WRONG RESULT
Date Fri, 11 Nov 2016 08:10:58 GMT

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

Teruyoshi Zenmyo commented on HIVE-15040:
-----------------------------------------

Sorry, my previous comment is incorrect.
HIVE-15175 is a dup of HIVE-14652, however, I have confirmed the HIVE-14652 patch does not
fix this issue.

> LATERAL VIEW + WHERE IN ...= WRONG RESULT
> -----------------------------------------
>
>                 Key: HIVE-15040
>                 URL: https://issues.apache.org/jira/browse/HIVE-15040
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 2.0.0
>            Reporter: Furcy Pin
>            Priority: Critical
>
> This query:
> {code}
> SELECT 
>   COUNT(1)
> FROM (
>   SELECT 1 as c1 , Array(1, 2, 3) as c2 
>   UNION ALL 
>   SELECT 2 as c1 , Array(2, 3, 4) as c2 
> ) T
> LATERAL VIEW explode(c2) LV AS c
> WHERE c = 42
> AND T.c1 NOT IN (SELECT 1 UNION ALL SELECT 3) 
> ;
> {code}
> returns {{3}} in Hive 1.1.0 and 2.0.0
> But obviously it should return 0, since {{c = 42}} is false.
> It seems that the clause is ignored.
> Spark-SQL does return {{0}}.
> P.S. The UNION ALL is not causing the bug, I just wanted to demonstrate is with a standalone
query. Using regular tables instead still causes the same bug.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message