[ 
https://issues.apache.org/jira/browse/HIVE-26485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17679896#comment-17679896
 ] 

Dayakar M commented on HIVE-26485:
----------------------------------

This is already fixed as a part of 
[HIVE-21518|https://issues.apache.org/jira/browse/HIVE-21518], please reverify 
the scenario once.

> 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
>            Priority: Major
>
> *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)

Reply via email to