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/07/26 13:36:35 UTC
[jira] [Created] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Namit Jain created HIVE-3304:
--------------------------------
Summary: sort merge join should work if both the tables are sorted in descending order
Key: HIVE-3304
URL: https://issues.apache.org/jira/browse/HIVE-3304
Project: Hive
Issue Type: Bug
Reporter: Namit Jain
Currently, sort merge join only works if both the tables are sorted in
ascending order
--
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
[jira] [Commented] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13425523#comment-13425523 ]
Namit Jain commented on HIVE-3304:
----------------------------------
The sort-merge join should work as long as the sorted columns list is the same as joined columns list,
and all the columns are sorted in the same order.
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Commented] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428585#comment-13428585 ]
Namit Jain commented on HIVE-3304:
----------------------------------
addressed - thanks for catching that
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch, hive.3304.2.patch, hive.3304.3.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Updated] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-3304:
-----------------------------
Component/s: Query Processor
Issue Type: New Feature (was: Bug)
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Commented] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428812#comment-13428812 ]
Namit Jain commented on HIVE-3304:
----------------------------------
fixed
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch, hive.3304.2.patch, hive.3304.3.patch, hive.3304.4.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Updated] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-3304:
-----------------------------
Attachment: hive.3304.4.patch
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch, hive.3304.2.patch, hive.3304.3.patch, hive.3304.4.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Updated] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-3304:
-----------------------------
Status: Patch Available (was: Open)
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch, hive.3304.2.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Commented] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Kevin Wilfong (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428798#comment-13428798 ]
Kevin Wilfong commented on HIVE-3304:
-------------------------------------
The tests failed.
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch, hive.3304.2.patch, hive.3304.3.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Commented] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13427921#comment-13427921 ]
Namit Jain commented on HIVE-3304:
----------------------------------
comments addressed
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch, hive.3304.2.patch, hive.3304.3.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Updated] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-3304:
-----------------------------
Attachment: hive.3304.3.patch
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch, hive.3304.2.patch, hive.3304.3.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Commented] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Kevin Wilfong (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428586#comment-13428586 ]
Kevin Wilfong commented on HIVE-3304:
-------------------------------------
+1
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch, hive.3304.2.patch, hive.3304.3.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Commented] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Kevin Wilfong (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428304#comment-13428304 ]
Kevin Wilfong commented on HIVE-3304:
-------------------------------------
One more comment on the diff.
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch, hive.3304.2.patch, hive.3304.3.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Commented] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13425630#comment-13425630 ]
Namit Jain commented on HIVE-3304:
----------------------------------
https://reviews.facebook.net/D4443
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Updated] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-3304:
-----------------------------
Status: Open (was: Patch Available)
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Assigned] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain reassigned HIVE-3304:
--------------------------------
Assignee: Namit Jain
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Commented] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Kevin Wilfong (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13428818#comment-13428818 ]
Kevin Wilfong commented on HIVE-3304:
-------------------------------------
Thanks, running tests again.
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch, hive.3304.2.patch, hive.3304.3.patch, hive.3304.4.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Updated] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-3304:
-----------------------------
Status: Patch Available (was: Open)
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Updated] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Kevin Wilfong (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kevin Wilfong updated HIVE-3304:
--------------------------------
Resolution: Fixed
Fix Version/s: 0.10.0
Status: Resolved (was: Patch Available)
Committed, thanks Namit.
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Fix For: 0.10.0
>
> Attachments: hive.3304.1.patch, hive.3304.2.patch, hive.3304.3.patch, hive.3304.4.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Commented] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Kevin Wilfong (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13427682#comment-13427682 ]
Kevin Wilfong commented on HIVE-3304:
-------------------------------------
Commented on the diff.
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch, hive.3304.2.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Updated] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-3304:
-----------------------------
Attachment: hive.3304.2.patch
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch, hive.3304.2.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Updated] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-3304:
-----------------------------
Attachment: hive.3304.1.patch
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: hive.3304.1.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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
[jira] [Commented] (HIVE-3304) sort merge join should work if both
the tables are sorted in descending order
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-3304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13429932#comment-13429932 ]
Hudson commented on HIVE-3304:
------------------------------
Integrated in Hive-trunk-h0.21 #1595 (See [https://builds.apache.org/job/Hive-trunk-h0.21/1595/])
HIVE-3304. sort merge join should work if both the tables are sorted in descending order. (njain via kevinwilfong) (Revision 1369879)
Result = SUCCESS
kevinwilfong : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1369879
Files :
* /hive/trunk/data/files/SortCol1Col2.txt
* /hive/trunk/data/files/SortCol2Col1.txt
* /hive/trunk/data/files/SortDescCol1Col2.txt
* /hive/trunk/data/files/SortDescCol2Col1.txt
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/optimizer/SortedMergeBucketMapJoinOptimizer.java
* /hive/trunk/ql/src/test/queries/clientpositive/bucket_map_join_1.q
* /hive/trunk/ql/src/test/queries/clientpositive/bucket_map_join_2.q
* /hive/trunk/ql/src/test/queries/clientpositive/sort_merge_join_desc_1.q
* /hive/trunk/ql/src/test/queries/clientpositive/sort_merge_join_desc_2.q
* /hive/trunk/ql/src/test/queries/clientpositive/sort_merge_join_desc_3.q
* /hive/trunk/ql/src/test/queries/clientpositive/sort_merge_join_desc_4.q
* /hive/trunk/ql/src/test/results/clientpositive/bucket_map_join_1.q.out
* /hive/trunk/ql/src/test/results/clientpositive/bucket_map_join_2.q.out
* /hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_1.q.out
* /hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_2.q.out
* /hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_3.q.out
* /hive/trunk/ql/src/test/results/clientpositive/sort_merge_join_desc_4.q.out
> sort merge join should work if both the tables are sorted in descending order
> -----------------------------------------------------------------------------
>
> Key: HIVE-3304
> URL: https://issues.apache.org/jira/browse/HIVE-3304
> Project: Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Fix For: 0.10.0
>
> Attachments: hive.3304.1.patch, hive.3304.2.patch, hive.3304.3.patch, hive.3304.4.patch
>
>
> Currently, sort merge join only works if both the tables are sorted in
> ascending order
--
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