[jira] [Commented] (DRILL-8209) Introduce rule for converting join with distinct input to semi-join

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

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

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

vvysotskyi opened a new pull request, #2533:
URL: https://github.com/apache/drill/pull/2533

   # [DRILL-8209](https://issues.apache.org/jira/browse/DRILL-8209): Introduce rule for converting join with distinct input to semi-join
   
   ## Description
   Newer Calcite changed the order of applying rules. AggregateRemoveRule is applied before SemiJoinRule, so SemiJoinRule cannot be applied later, since aggregate is pruned from planning.
   
   Adding rule that converts join to semi-join if the right side has distinct columns.
   Fixed cost and row count computation for semi-join.
   
   ## Documentation
   NA
   
   ## Testing
   Unit tests pass
   




> Introduce rule for converting join with distinct input to semi-join
> -------------------------------------------------------------------
>
>                 Key: DRILL-8209
>                 URL: https://issues.apache.org/jira/browse/DRILL-8209
>             Project: Apache Drill
>          Issue Type: Sub-task
>            Reporter: Vova Vysotskyi
>            Assignee: Vova Vysotskyi
>            Priority: Major
>
> Newer Calcite changed the order of applying rules. AggregateRemoveRule is applied before SemiJoinRule, so SemiJoinRule cannot be applied later, since aggregate is pruned from planning.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)