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

[ASF GitHub Bot (Jira)]

    [ 
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 & Optimization
>            Reporter: Victoria Markman
>            Assignee: Tengfei Wang
>            Priority: Major
>




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