[jira] [Created] (IGNITE-18464) Sql. Colocated sort aggregates need to compose a plans with additional sort if no appropriate index is available.

["Evgeny Stanilovsky (Jira)" <ji...@apache.org>]

Evgeny Stanilovsky created IGNITE-18464:
-------------------------------------------

             Summary: Sql. Colocated sort aggregates need to compose a plans with additional sort if no appropriate index is available. 
                 Key: IGNITE-18464
                 URL: https://issues.apache.org/jira/browse/IGNITE-18464
             Project: Ignite
          Issue Type: Improvement
          Components: sql
    Affects Versions: 3.0.0-beta1
            Reporter: Evgeny Stanilovsky


For now requests like :
{noformat}
SELECT COUNT(DISTINCT val0) FROM test{noformat}
Can`t be planned through SortAggregates, ("ColocatedHashAggregateConverterRule", "MapReduceHashAggregateConverterRule") - need to be disabled. 

But seems we need to obtain smth like :
{noformat}
IgniteProject
  IgniteReduceSortAggregate
    IgniteExchange
      IgniteMapSortAggregate
        IgniteSort <-?
          IgniteTableScan{noformat}
Seems map aggregate not require sorted input or smth about it.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)