Manthan B Y created HIVE-26485:
----------------------------------
Summary: SELECT query with IS DISTINCT FROM operator is failing
with RuntimeException
Key: HIVE-26485
URL: https://issues.apache.org/jira/browse/HIVE-26485
Project: Hive
Issue Type: Bug
Reporter: Manthan B Y
*Steps to Reproduce:*
# Open a beeline session
# Execute the following queries
{code:java}
CREATE TABLE IF NOT EXISTS t1(c0 DOUBLE PRIMARY KEY DISABLE NOVALIDATE, c1
integer );
CREATE VIEW v0 AS (SELECT DISTINCT t1.c1 AS cv0 FROM t1 WHERE
(((t1.c0)<(t1.c1))) IS TRUE);
INSERT INTO t1 VALUES(0, 1);
SELECT cast((('F' LIKE '')
OR (
12 IS DISTINCT FROM v0.cv0)) AS int) AS count
FROM v0;{code}
*Result:*
{code:java}
Error while compiling statement: FAILED: RuntimeException Cannot run all parts
of query in llap. Failing since hive.llap.execution.mode is set to only {code}
*Note:* Same query with {{IS NOT DISTINCT FROM}} operator works without any
error.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
