[ 
https://issues.apache.org/jira/browse/IGNITE-20095?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Andrey Mashenkov updated IGNITE-20095:
--------------------------------------
    Description: 
See examples in MapReduceSortAggregatePlannerTest. 
Looks like, Map aggregate can't utilize sorting from the input in some cases.

  was:
See examples in MapReduceSortAggregatePlannerTest:


{code:java}
SELECT val0, val1, COUNT(*) cnt FROM test GROUP BY val0, val1 ORDER BY val0.
CASE_19_1
Distribution single

aggregateWithOrderBySubsetOfGroupColumns
{code}

{code:java}
 assertPlan(testCase,
                isInstanceOf(IgniteReduceSortAggregate.class)
                        .and(input(isInstanceOf(IgniteMapSortAggregate.class) 
//TODO: Why can't Map be pushed down to under 'exchange'.
                                .and(input(isInstanceOf(IgniteSort.class)
                                        .and(s -> 
s.collation().equals(collation))
                                        .and(input(isTableScan("TEST")))
                                ))
                        )),
                disableRules
        );
{code}



> Sql. Map part of MAP/REDUCE aggregate sometimes can not be moved past 
> Exchange.
> -------------------------------------------------------------------------------
>
>                 Key: IGNITE-20095
>                 URL: https://issues.apache.org/jira/browse/IGNITE-20095
>             Project: Ignite
>          Issue Type: Improvement
>          Components: sql
>            Reporter: Maksim Zhuravkov
>            Priority: Minor
>              Labels: ignite-3
>
> See examples in MapReduceSortAggregatePlannerTest. 
> Looks like, Map aggregate can't utilize sorting from the input in some cases.



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

Reply via email to