[
https://issues.apache.org/jira/browse/TAJO-1525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14484755#comment-14484755
]
Keuntae Park commented on TAJO-1525:
------------------------------------
At first, I thought that new physical operator is only for INTERSECT ALL and
INTERSECT would be handled by INTERSECT ALL + distinct.
But, during implementation, I found that single physical operator for INTERSECT
and INTERSECT ALL is much better approach
because it results in much simpler plan for INTERSECT.
So, I'll update patch to implement single physical operator to support both
INTERSECT and INTERSECT ALL.
> 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)
