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