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

["Gopal V (JIRA)" <ji...@apache.org>]

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

Gopal V commented on HIVE-16367:
--------------------------------

Can you print the OptimizedSQL for this pattern - to see the x-prod location?

> 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
>            Priority: Major
>         Attachments: HIVE-16367.1.patch
>
>
> Calcite doesn't support such equality operator so hive bails out and goes through non-cbo path. This could restrict it's usage 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
(v7.6.3#76005)