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

Posted to dev@hive.apache.org by "Deepak Jaiswal (JIRA)" <ji...@apache.org> on 2017/01/20 07:56:26 UTC

[jira] [Created] (HIVE-15677) Remove semijoin optimization if the tables involved have PK-FK relationship

Deepak Jaiswal created HIVE-15677:
-------------------------------------

             Summary: Remove semijoin optimization if the tables involved have PK-FK relationship
                 Key: HIVE-15677
                 URL: https://issues.apache.org/jira/browse/HIVE-15677
             Project: Hive
          Issue Type: Improvement
            Reporter: Deepak Jaiswal
            Assignee: Deepak Jaiswal


If a semijoin optimization is created on tables which have PK-FK relationship on join keys(e.g. customer-order ) then the reduction will not take place.
Remove the optimization in such cases.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)