[
https://issues.apache.org/jira/browse/HIVE-29181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18056270#comment-18056270
]
Stamatis Zampetakis commented on HIVE-29181:
--------------------------------------------
[~Dayakar] [~thomasrebele] not sure what repro issues you had but since the
problem is somewhat related to the HiveFilterProjectTransposeRule note that
some changes strongly connected to this rule have been merged recently in
master as part of HIVE-29380.
> SELECT query on VIEW with IS NOT NULL operator producing unexpected result
> --------------------------------------------------------------------------
>
> Key: HIVE-29181
> URL: https://issues.apache.org/jira/browse/HIVE-29181
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Affects Versions: 4.0.1
> Reporter: Dayakar M
> Assignee: Dayakar M
> Priority: Major
> Labels: correctness, pull-request-available
>
> SELECT query on VIEW with IS NOT NULL operator producing unexpected result
> Reproduce Steps:
> {noformat}
> CREATE TABLE IF NOT EXISTS t1(c0 DOUBLE, c1 FLOAT, c2 integer);
> CREATE VIEW v0 AS (SELECT ALL (t1.c1) AS c0 FROM t1);
> INSERT INTO t1(c0) VALUES(0.3485010744027526);
> INSERT INTO t1(c1) VALUES(8.574871E8), (8.574871E8), (0.053164534),
> (0.11833945), (0.83558863);
> -- Returning 6 rows
> SELECT v0.c0 FROM v0 WHERE ((1008753865)/(0)) IS NOT NULL;{noformat}
> Where as with same where clause expression for table its working fine.
> {noformat}
> -- Returns 0 rows
> SELECT t1.c0 from t1 WHERE ((1008753865)/(0)) IS NOT NULL;{noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
