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