[ https://issues.apache.org/jira/browse/CALCITE-1447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15645862#comment-15645862 ]
Pengcheng Xiong commented on CALCITE-1447: ------------------------------------------ new PR: https://github.com/apache/calcite/pull/323 > 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 > 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)