[jira] [Commented] (IGNITE-18871) Sql. ColocatedSortAggregate rule can't use index for grouping

["Konstantin Orlov (Jira)" <ji...@apache.org>]

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

Konstantin Orlov commented on IGNITE-18871:
-------------------------------------------

[~amashenkov], [~zstan], guys, could you take a look please?

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