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

Posted to issues@drill.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2022/07/17 12:02:00 UTC

[jira] [Commented] (DRILL-4232) Support for EXCEPT set operator

    [ https://issues.apache.org/jira/browse/DRILL-4232?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17567620#comment-17567620 ] 

ASF GitHub Bot commented on DRILL-4232:
---------------------------------------

Leon-WTF opened a new pull request, #2599:
URL: https://github.com/apache/drill/pull/2599

   # [DRILL-4232](https://issues.apache.org/jira/browse/DRILL-4232): Support for EXCEPT and INTERSECT set operator
   
   ## Description
   Can have hash set operator and sorted set operator, only implement hash version in this PR.
   Compute number of left-input duplicates(numLeft) and number of left-input duplicates(numRight) for each same tuple:
   INTERSECT: if numRight > 0 and numLeft > 0, output one tuple
   INTERSECT ALL: if numRight > 0 and numLeft > 0, output min(numLeft,numRight) tuples
   EXCEPT: if numRight = 0 and numLeft > 0, output one tuple
   EXCEPT ALL: if numRight = 0 and numLeft > 0, output numLeft - numRight tuples
   
   ## Documentation
   TODO
   
   ## Testing
   TODO




> Support for EXCEPT set operator
> -------------------------------
>
>                 Key: DRILL-4232
>                 URL: https://issues.apache.org/jira/browse/DRILL-4232
>             Project: Apache Drill
>          Issue Type: New Feature
>          Components: Query Planning &amp; Optimization
>            Reporter: Victoria Markman
>            Assignee: Tengfei Wang
>            Priority: Major
>




--
This message was sent by Atlassian Jira
(v8.20.10#820010)