[jira] [Commented] (CALCITE-1447) Support INTERSECT DISTINCT

["Pengcheng Xiong (JIRA)" <ji...@apache.org>]

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

Pengcheng Xiong commented on CALCITE-1447:
------------------------------------------

[~julianhyde], [~jcamachorodriguez] and [~ashutoshc] could u take a look? Thanks.

> Support INTERSECT DISTINCT
> --------------------------
>
>                 Key: CALCITE-1447
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1447
>             Project: Calcite
>          Issue Type: Sub-task
>            Reporter: Pengcheng Xiong
>            Assignee: Pengcheng Xiong
>         Attachments: CALCITE-1447.01.patch
>
>
> Interesect distinct will be rewritten as 
> {code}
> Rewrite: (GB-Union All-GB)-GB-FIL-Proj
>     Example: R1 Intersect All R2
>     R3 = GB(R1 on all attributes + count() as c) union all GB(R2 on all attributes + count() as c)
>     R4 = GB(R3 on all attributes + count(c) as cnt)
>     R5 = Fil ( cnt == #branch )
>     R6 = Proj(R5 on all attributes)
> {code}



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