You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Namit Jain (JIRA)" <ji...@apache.org> on 2012/12/06 06:14:57 UTC
[jira] [Created] (HIVE-3774) Sort merge join should work if join
cols are a prefix of sort columns for each partition
Namit Jain created HIVE-3774:
--------------------------------
Summary: 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
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] [Updated] (HIVE-3774) Sort merge join should work if join
cols are a prefix of sort columns for each partition
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-3774:
-----------------------------
Attachment: hive.3774.1.patch
> 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
[jira] [Updated] (HIVE-3774) Sort merge join should work if join
cols are a prefix of sort columns for each partition
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-3774:
-----------------------------
Status: Patch Available (was: Open)
> 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
[jira] [Commented] (HIVE-3774) Sort merge join should work if join
cols are a prefix of sort columns for each partition
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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