[jira] [Commented] (HIVE-3774) Sort merge join should work if join cols are a prefix of sort columns for each partition
[ https://issues.apache.org/jira/browse/HIVE-3774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13548258#comment-13548258 ] Hudson commented on HIVE-3774: -- Integrated in Hive-trunk-hadoop2 #54 (See [https://builds.apache.org/job/Hive-trunk-hadoop2/54/]) HIVE-3774. Sort merge join should work if join cols are a prefix of sort columns for each partition. (njain via kevinwilfong) (Revision 1424083) Result = ABORTED kevinwilfong : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1424083 Files : * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SortedMergeBucketMapJoinOptimizer.java * /hive/trunk/ql/src/test/queries/clientpositive/smb_mapjoin_15.q * /hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_15.q.out Sort merge join should work if join cols are a prefix of sort columns for each partition Key: HIVE-3774 URL: https://issues.apache.org/jira/browse/HIVE-3774 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Namit Jain Fix For: 0.11.0 Attachments: hive.3774.1.patch, hive.3774.2.patch, hive.3774.3.patch Currently, a join is converted into a sort-merge join only if the join cols exactly matches the sort cols. This constraint can definitely be relaxed. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3774) Sort merge join should work if join cols are a prefix of sort columns for each partition
[ https://issues.apache.org/jira/browse/HIVE-3774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13536824#comment-13536824 ] Hudson commented on HIVE-3774: -- Integrated in Hive-trunk-h0.21 #1867 (See [https://builds.apache.org/job/Hive-trunk-h0.21/1867/]) HIVE-3774. Sort merge join should work if join cols are a prefix of sort columns for each partition. (njain via kevinwilfong) (Revision 1424083) Result = SUCCESS kevinwilfong : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVNview=revrev=1424083 Files : * /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SortedMergeBucketMapJoinOptimizer.java * /hive/trunk/ql/src/test/queries/clientpositive/smb_mapjoin_15.q * /hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_15.q.out Sort merge join should work if join cols are a prefix of sort columns for each partition Key: HIVE-3774 URL: https://issues.apache.org/jira/browse/HIVE-3774 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Namit Jain Fix For: 0.11 Attachments: hive.3774.1.patch, hive.3774.2.patch, hive.3774.3.patch Currently, a join is converted into a sort-merge join only if the join cols exactly matches the sort cols. This constraint can definitely be relaxed. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3774) Sort merge join should work if join cols are a prefix of sort columns for each partition
[ https://issues.apache.org/jira/browse/HIVE-3774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13532882#comment-13532882 ] Kevin Wilfong commented on HIVE-3774: - +1 Sort merge join should work if join cols are a prefix of sort columns for each partition Key: HIVE-3774 URL: https://issues.apache.org/jira/browse/HIVE-3774 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Namit Jain Attachments: hive.3774.1.patch, hive.3774.2.patch, hive.3774.3.patch Currently, a join is converted into a sort-merge join only if the join cols exactly matches the sort cols. This constraint can definitely be relaxed. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3774) Sort merge join should work if join cols are a prefix of sort columns for each partition
[ https://issues.apache.org/jira/browse/HIVE-3774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13529808#comment-13529808 ] Namit Jain commented on HIVE-3774: -- comments addressed Sort merge join should work if join cols are a prefix of sort columns for each partition Key: HIVE-3774 URL: https://issues.apache.org/jira/browse/HIVE-3774 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Namit Jain Attachments: hive.3774.1.patch, hive.3774.2.patch Currently, a join is converted into a sort-merge join only if the join cols exactly matches the sort cols. This constraint can definitely be relaxed. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3774) Sort merge join should work if join cols are a prefix of sort columns for each partition
[ https://issues.apache.org/jira/browse/HIVE-3774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13530082#comment-13530082 ] Namit Jain commented on HIVE-3774: -- tests passed Sort merge join should work if join cols are a prefix of sort columns for each partition Key: HIVE-3774 URL: https://issues.apache.org/jira/browse/HIVE-3774 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Namit Jain Attachments: hive.3774.1.patch, hive.3774.2.patch, hive.3774.3.patch Currently, a join is converted into a sort-merge join only if the join cols exactly matches the sort cols. This constraint can definitely be relaxed. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (HIVE-3774) Sort merge join should work if join cols are a prefix of sort columns for each partition
[ https://issues.apache.org/jira/browse/HIVE-3774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13511234#comment-13511234 ] Namit Jain commented on HIVE-3774: -- https://reviews.facebook.net/D7179 Sort merge join should work if join cols are a prefix of sort columns for each partition Key: HIVE-3774 URL: https://issues.apache.org/jira/browse/HIVE-3774 Project: Hive Issue Type: Bug Components: Query Processor Reporter: Namit Jain Assignee: Namit Jain Attachments: hive.3774.1.patch Currently, a join is converted into a sort-merge join only if the join cols exactly matches the sort cols. This constraint can definitely be relaxed. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira