[ https://issues.apache.org/jira/browse/HIVE-7384?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14085110#comment-14085110 ]
Brock Noland edited comment on HIVE-7384 at 8/12/14 12:44 AM: -------------------------------------------------------------- I am using the attached three files when playing around on this issue and the query: {noformat} select * from product full outer join item on (product.product_pk = item.product_pk); {noformat} was (Author: brocknoland): I am using the attached three files when playing around on this issue and the query: {noformat} select * from product join item on (product.product_pk = item.product_pk); {noformat} > Research into reduce-side join > ------------------------------ > > Key: HIVE-7384 > URL: https://issues.apache.org/jira/browse/HIVE-7384 > Project: Hive > Issue Type: Sub-task > Components: Spark > Reporter: Xuefu Zhang > Assignee: Szehon Ho > Attachments: sales_items.txt, sales_products.txt, sales_stores.txt > > > Hive's join operator is very sophisticated, especially for reduce-side join. > While we expect that other types of join, such as map-side join and SMB > map-side join, will work out of the box with our design, there may be some > complication in reduce-side join, which extensively utilizes key tag and > shuffle behavior. Our design principle prefers to making Hive implementation > work out of box also, which might requires new functionality from Spark. The > tasks is to research into this area, identifying requirements for Spark > community and the work to be done on Hive to make reduce-side join work. > A design doc might be needed for this. For more information, please refer to > the overall design doc on wiki. -- This message was sent by Atlassian JIRA (v6.2#6252)