[
https://issues.apache.org/jira/browse/HIVE-25533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Needn Yu updated HIVE-25533:
----------------------------
Attachment: (was: 微信图片_20210917111715.png)
> Incorrect query result when using where CLAUSE to query data from 2 "UNION
> ALL" parts
> -------------------------------------------------------------------------------------
>
> 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 n1VALUES('needn');
> CREATE VIEW v1AS
> SELECT 'maggie' FROM n1
> UNION ALL
> SELECT c1 FROM v1;
> {code}
> Return the incorrect result when using "=" or "IN" with single element.
> For example, the following 2 querys return nothing.
> {code:java}
> SELECT * FROM v1WHERE c1 = 'maggie';
> SELECT * FROM v1WHERE 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 v1WHERE c1 IN ('maggie','This is a bug');
> SELECT * FROM v1WHERE c1 LIKE 'maggie%';
> {code}
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
