Description
Using beer-sample, create a partitioned index with (1) index-key matches group-by key, (2) index-key matches partition key.
create index category on `beer-sample`(category) partition by hash(category);
Aggregate query is push-down to partitioned index, expecting full-aggregate result. Gsi client returns full aggregated result in sorted order, but the final query result is not in sorted order.
cbq> select category, count(category) from `beer-sample` where category is not missing group by category order by category;
{
"requestID": "7828e134-f4b3-4c9c-aa48-61f41ac0042f",
"signature":
,
"results": [
,
,
,
,
,
,
,
,
{ "$1": 441, "category": "German Lager" } ],
"status": "success",
"metrics":
}