[
https://issues.apache.org/jira/browse/HIVE-29181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18034239#comment-18034239
]
Dmitriy Fingerman commented on HIVE-29181:
------------------------------------------
I checked on 4.0.1 - the issue is present there.
> 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)
