Details
-
Type:
Sub-task
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.11.0
-
Component/s: None
-
Labels:None
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)