[
https://issues.apache.org/jira/browse/TAJO-1525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Keuntae Park updated TAJO-1525:
-------------------------------
Description:
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}
INTERSECT can be implemented by selecting distinct result of above physical
operator.
was:
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}
> 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}
> INTERSECT can be implemented by selecting distinct result of above physical
> operator.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
