[
https://issues.apache.org/jira/browse/TAJO-1525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14481014#comment-14481014
]
ASF GitHub Bot commented on TAJO-1525:
--------------------------------------
GitHub user sirpkt opened a pull request:
https://github.com/apache/tajo/pull/513
TAJO-1525: Implement INTERSECT ALL physical operator
This patch implements sort based INTERSECT ALL physical operator.
INTERSECT ALL operator has two input physical operators that should return
rows sorted by all the schema columns.
Then, it iterates results of both children operators and returns the common
rows from both.
- SetTupleComparator is implemented to compare the whole columns of given
two tuples.
- Test code is also included, which tests INTERSECT ALL exec by replacing
inner join with it. It is somewhat tricky, however, useful way when Logical
Planner and Global Planner are not ready for INTERSECT [ALL].
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sirpkt/tajo TAJO-1525
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/tajo/pull/513.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #513
----
commit fdba6a66a8bb71fee14468929251cb87c624ff27
Author: Keuntae Park <[email protected]>
Date: 2015-04-06T06:41:38Z
Implement SortIntersetAllExec, sort based INTERSECT ALL physical operator
----
> Implement INTERSECT ALL physical operator
> -----------------------------------------
>
> Key: TAJO-1525
> URL: https://issues.apache.org/jira/browse/TAJO-1525
> Project: Tajo
> Issue Type: Sub-task
> Reporter: Keuntae Park
> Assignee: Keuntae Park
>
> As discussed in TAJO-1517,
> INTERSECT ALL needs new physical operator,
> which returns the exact number of overlapping rows between results of two
> query blocks.
> For example, when query1 returns
> {code}
> 1, 3, 3, 3
> {code}
> while query2 returns
> {code}
> 3, 3
> {code}
> query1 INTERSECT ALL query2 should return
> {code}
> 3, 3
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
