[ 
https://issues.apache.org/jira/browse/SPARK-11512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15006975#comment-15006975
 ] 

Alex Nastetsky commented on SPARK-11512:
----------------------------------------

There are 3 situations:

1) dataset A and dataset B are both partitioned/sorted the same on disk and 
need to be joined. should be able to take advantage of their partitioning/sort.
2) dataset A is partitioned/sorted on disk, dataset B gets generated during the 
app run and needs to be joined to dataset A. should be able to take advantage 
of dataset A's partitioning/sort and mimic the same partitioning/sort on 
dataset B, without having to pre-process dataset A. perhaps, something like 
repartitionAndSortWithinPartitions to be performed on dataset B?
3) dataset A and B are both generated during the app run and need to be joined. 
I believe doing a Sort Merge Join on these is already supported in SPARK-2213.

The first 2 situations is what this ticket is for.

> Bucket Join
> -----------
>
>                 Key: SPARK-11512
>                 URL: https://issues.apache.org/jira/browse/SPARK-11512
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>            Reporter: Cheng Hao
>
> Sort merge join on two datasets on the file system that have already been 
> partitioned the same with the same number of partitions and sorted within 
> each partition, and we don't need to sort it again while join with the 
> sorted/partitioned keys
> This functionality exists in
> - Hive (hive.optimize.bucketmapjoin.sortedmerge)
> - Pig (USING 'merge')
> - MapReduce (CompositeInputFormat)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to