[
https://issues.apache.org/jira/browse/HIVE-16367?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15980585#comment-15980585
]
Vineet Garg commented on HIVE-16367:
------------------------------------
Attaching initial patch which enables CBO for {{<=>}} by rewriting it into {{is
not distinct from}}. This patch has an issue where a join with {{<=>}} is now
cross product instead of inner join. This needs to be investigated and fixed.
> 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
> 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
(v6.3.15#6346)
