[
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)