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