You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Vineet Garg (JIRA)" <ji...@apache.org> on 2017/04/04 00:27:41 UTC

[jira] [Created] (HIVE-16367) Null-safe equality <=> operator is not support with CBO

Vineet Garg created HIVE-16367:
----------------------------------

             Summary: Null-safe equality <=> operator is not support with CBO 
                 Key: HIVE-16367
                 URL: https://issues.apache.org/jira/browse/HIVE-16367
             Project: Hive
          Issue Type: Improvement
            Reporter: Vineet Garg
            Assignee: Vineet Garg


Calcite doesn't support such equality operator so hive bails out and goes through non-cbo path. This could restrict such operators with subqueries and other cbo only features.

Since {{<=>}} is equivalent to {{is not distinct from}} (HIVE-15986) we can rewrite {{<=>}} to {{is not distinct from}} and enable CBO.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)