[jira] [Created] (HIVE-25533) Incorrect query result when using where CLAUSE to query data from 2 "UNION ALL" parts

["Needn Yu (Jira)" <ji...@apache.org>]

Needn Yu created HIVE-25533:
-------------------------------

             Summary: 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
         Attachments: 微信图片_20210917111715.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)