[CALCITE-1447] Implement INTERSECT DISTINCT by rewriting to UNION ALL and counting

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.11.0
• Assignee: Pengcheng Xiong
• Reporter: Pengcheng Xiong
• Created: 17/Oct/16 23:20
• Updated: 06/Jan/17 19:30
• Resolved: 09/Nov/16 00:11

Description

Interesect distinct will be rewritten as

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)