[ https://issues.apache.org/jira/browse/HIVE-3086?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428568#comment-13428568 ]
alex gemini commented on HIVE-3086: ----------------------------------- @Yongqiang We don't need hint here,the above example is just for clarify.The main point here is if some key is skewed ,just mixed this key with another low selectivity key like primary key.Use this composite key as input for hash partition. > Skewed Join Optimization > ------------------------ > > Key: HIVE-3086 > URL: https://issues.apache.org/jira/browse/HIVE-3086 > Project: Hive > Issue Type: New Feature > Reporter: Nadeem Moidu > Assignee: Nadeem Moidu > > During a join operation, if one of the columns has a skewed key, it can cause > that particular reducer to become the bottleneck. The following feature will > address it: > https://cwiki.apache.org/confluence/display/Hive/Skewed+Join+Optimization -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira