[jira] [Updated] (HIVE-25533) Incorrect results when filtering data from UNION ALL sub-query

["Stamatis Zampetakis (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-25533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Stamatis Zampetakis updated HIVE-25533:
---------------------------------------
    Summary: Incorrect results when filtering data from UNION ALL sub-query  (was: With CBO enabled, Incorrect query result when using where CLAUSE to query data from 2 "UNION ALL" parts)

> Incorrect results when filtering data from UNION ALL sub-query
> --------------------------------------------------------------
>
>                 Key: HIVE-25533
>                 URL: https://issues.apache.org/jira/browse/HIVE-25533
>             Project: Hive
>          Issue Type: Bug
>          Components: Database/Schema
>    Affects Versions: 3.1.0
>         Environment: Azure HDInsight 4.1.7.5
> Hive 3.1.0
>            Reporter: Needn Yu
>            Priority: Critical
>         Attachments: hive.png
>
>
> When querying form a view or CTE which "union all" 2 tables, such as the following script shows
> {code:java}
> CREATE TABLE n1 (c1 STRING);
> INSERT OVERWRITE TABLE n1 VALUES('needn');
> CREATE VIEW v1 
> AS
> SELECT 'maggie'  AS c1 FROM n1
> UNION ALL
> SELECT c1 FROM n1;
> {code}
> Return the incorrect result when using "=" or "IN" with single element.
> For example, the following 2 querys return nothing.
> {code:java}
> SELECT * FROM v1 WHERE c1 = 'maggie';
> SELECT * FROM v1 WHERE c1 IN ('maggie');{code}
>  
> However, I can get correct result when using "LIKE" or "IN" with multiple element.
> For example, the following 2 querys return expected result.
> {code:java}
> SELECT * FROM v1 WHERE c1 IN ('maggie','This is a bug');
> SELECT * FROM v1 WHERE c1 LIKE 'maggie%';
> {code}
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)