You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@beam.apache.org by "Rui Wang (JIRA)" <ji...@apache.org> on 2019/01/14 22:17:00 UTC

[jira] [Created] (BEAM-6427) INTERSECT ALL is not compatible with SQL standard

Rui Wang created BEAM-6427:
------------------------------

             Summary: INTERSECT ALL is not compatible with SQL standard
                 Key: BEAM-6427
                 URL: https://issues.apache.org/jira/browse/BEAM-6427
             Project: Beam
          Issue Type: Improvement
          Components: dsl-sql
            Reporter: Rui Wang
            Assignee: Rui Wang


say Row R appears m times on one side and n times on another side. 

Beam's  INTERSECT ALL is implemented to return MAX(m, n).

And SQL1999 standard says INTERSECT ALL should return MIN(m, n).



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)