You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "mahesh kumar behera (Jira)" <ji...@apache.org> on 2021/08/06 05:08:00 UTC

[jira] [Created] (HIVE-25431) Enable CBO for null safe equality operator.

mahesh kumar behera created HIVE-25431:
------------------------------------------

             Summary: Enable CBO for null safe equality operator.
                 Key: HIVE-25431
                 URL: https://issues.apache.org/jira/browse/HIVE-25431
             Project: Hive
          Issue Type: Bug
          Components: Hive, HiveServer2
            Reporter: mahesh kumar behera
            Assignee: mahesh kumar behera


The CBO is disabled for null safe equality (<=>)  operator. This is causing the sub optimal join execution  for some queries. As null safe equality is supported by joins, the CBO can be enabled for it. There will be issues with join reordering as Hive does not support join reordering for null safe equality operator. But with CBO enabled the join plan will be better.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)