[jira] [Updated] (CALCITE-1447) Implement INTERSECT DISTINCT by rewriting to UNION ALL and counting

["Julian Hyde (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CALCITE-1447?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde updated CALCITE-1447:
---------------------------------
    Summary: Implement INTERSECT DISTINCT by rewriting to UNION ALL and counting  (was: Support INTERSECT DISTINCT)

> Implement INTERSECT DISTINCT by rewriting to UNION ALL and counting
> -------------------------------------------------------------------
>
>                 Key: CALCITE-1447
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1447
>             Project: Calcite
>          Issue Type: Sub-task
>            Reporter: Pengcheng Xiong
>            Assignee: Pengcheng Xiong
>             Fix For: 1.11.0
>
>         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)