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 2008/12/24 00:24:46 UTC
[jira] Created: (HIVE-195) map-side joins are not supported
map-side joins are not supported
--------------------------------
Key: HIVE-195
URL: https://issues.apache.org/jira/browse/HIVE-195
Project: Hadoop Hive
Issue Type: New Feature
Components: Query Processor
Reporter: Namit Jain
Assignee: Namit Jain
map-side joins are not supported.
If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Status: Open (was: Patch Available)
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Status: Patch Available (was: Open)
added more tests
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Attachment: hive.195.8.patch
The output of join27.q was non-deterministic - fixing that
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt, hive.195.4.patch, hive.195.5.patch, hive.195.6.patch, hive.195.7.patch, hive.195.8.patch
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Attachment: 195.patch3.txt
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Status: Open (was: Patch Available)
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Status: Patch Available (was: Open)
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Attachment: hive.195.6.patch
merged conflicts with 467
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt, hive.195.4.patch, hive.195.5.patch, hive.195.6.patch
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Attachment: hive.195.7.patch
more conflicts
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt, hive.195.4.patch, hive.195.5.patch, hive.195.6.patch, hive.195.7.patch
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Status: Patch Available (was: Open)
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Attachment: 195.patch2.txt
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-195) map-side joins are not supported
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12716061#action_12716061 ]
Ashish Thusoo commented on HIVE-195:
------------------------------------
+1
Running test now. Will checkin once it is done.
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt, hive.195.4.patch, hive.195.5.patch, hive.195.6.patch, hive.195.7.patch
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Attachment: hive.195.5.patch
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt, hive.195.4.patch, hive.195.5.patch
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Attachment: hive.195.9.patch
missed the testoperators - the test needs to change - missed that since it does not show up failures
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt, hive.195.4.patch, hive.195.5.patch, hive.195.6.patch, hive.195.7.patch, hive.195.8.patch, hive.195.9.patch
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-195) map-side joins are not supported
Posted by "Joydeep Sen Sarma (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12659733#action_12659733 ]
Joydeep Sen Sarma commented on HIVE-195:
----------------------------------------
here's the ticket for the jdbm enhancement that might help:
https://sourceforge.net/tracker/?func=detail&atid=354155&aid=2475914&group_id=4155
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Status: Open (was: Patch Available)
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12715624#action_12715624 ]
Namit Jain commented on HIVE-195:
---------------------------------
Some cleanups can be performed in follow-ups.
Filed new JIRAS:
https://issues.apache.org/jira/browse/HIVE-528
https://issues.apache.org/jira/browse/HIVE-529
https://issues.apache.org/jira/browse/HIVE-530
https://issues.apache.org/jira/browse/HIVE-531
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Zheng Shao (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zheng Shao updated HIVE-195:
----------------------------
Resolution: Fixed
Fix Version/s: 0.4.0
Release Note: HIVE-195. Map-side join. (Namit Jain via zshao)
Hadoop Flags: [Reviewed]
Status: Resolved (was: Patch Available)
Committed. Thanks Namit!
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Fix For: 0.4.0
>
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt, hive.195.4.patch, hive.195.5.patch, hive.195.6.patch, hive.195.7.patch, hive.195.8.patch, hive.195.9.patch
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HIVE-195) map-side joins are not supported
Posted by "Ashish Thusoo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12716068#action_12716068 ]
Ashish Thusoo commented on HIVE-195:
------------------------------------
Tests are failing on my run.
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt, hive.195.4.patch, hive.195.5.patch, hive.195.6.patch, hive.195.7.patch
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Attachment: 195.patch1.txt
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Attachment: hive.195.4.patch
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt, hive.195.4.patch
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-195) map-side joins are not supported
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-195?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-195:
----------------------------
Status: Patch Available (was: Open)
> map-side joins are not supported
> --------------------------------
>
> Key: HIVE-195
> URL: https://issues.apache.org/jira/browse/HIVE-195
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Namit Jain
> Assignee: Namit Jain
> Attachments: 195.patch1.txt, 195.patch2.txt, 195.patch3.txt, hive.195.4.patch, hive.195.5.patch
>
>
> map-side joins are not supported.
> If all the tables but one are small and can fit in memory, the join should be performed on the map-side. Ideally, it should be all cost-based, but
> to start with, the user should be given an option to specify that he needs a map-side join.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.