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)