[ https://issues.apache.org/jira/browse/IGNITE-18871?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Konstantin Orlov updated IGNITE-18871: -------------------------------------- Ignite Flags: (was: Docs Required,Release Notes Required) > Sql. ColocatedSortAggregate rule can't use index for grouping. > -------------------------------------------------------------- > > Key: IGNITE-18871 > URL: https://issues.apache.org/jira/browse/IGNITE-18871 > Project: Ignite > Issue Type: Improvement > Components: sql > Reporter: Andrey Mashenkov > Assignee: Konstantin Orlov > Priority: Major > Labels: ignite-3 > Fix For: 3.0.0-beta2 > > > Assume there is a table with a composite index on (grp0, grp1) columns. > ColocatedSortAggregate rule can’t use index for the next query in case of > hash distribution: > {code:java} > SELECT AVG(val0) FROM test GROUP BY grp1, grp0 > {code} > However, index is for the query used in case of single distribution. > Also, index is used for the next query in both cases: single and hash > distributions. > {code:java} > SELECT AVG(val0) FROM test GROUP BY grp0, grp1 > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)