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

[Andrey Mashenkov (Jira)]

Andrey Mashenkov created IGNITE-18871:
-----------------------------------------

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