Dayakar M created HIVE-29181:
--------------------------------
Summary: 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
Reporter: Dayakar M
Assignee: Dayakar M
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)
