[
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)
