You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Needn Yu (Jira)" <ji...@apache.org> on 2021/09/17 04:43:00 UTC
[jira] [Updated] (HIVE-25533) With CBO enabled, Incorrect query
result when using where CLAUSE to query data from 2 "UNION ALL" parts
[ https://issues.apache.org/jira/browse/HIVE-25533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Needn Yu updated HIVE-25533:
----------------------------
Summary: With CBO enabled, Incorrect query result when using where CLAUSE to query data from 2 "UNION ALL" parts (was: Incorrect query result when using where CLAUSE to query data from 2 "UNION ALL" parts)
> With CBO enabled, 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 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)