Details
-
Improvement
-
Resolution: Done
-
Critical
-
4.0.0
-
Security Level: Public
-
3 data node, 1 query node, 1 index node. 20M documents, one 2i index on key (email)
Description
cbq> select count, capped_small from `bucket-1` group by capped_small;
{
"requestID": "e6071bb0-de55-48a0-9ff2-d13b83a6205c",
"errors": [
],
"status": "fatal",
"metrics":
}
cbq> explain select count, capped_small from `bucket-1` group by capped_small;
{
"requestID": "69078f8b-0127-4623-9772-6cdb0ec84f7a",
"errors": [
],
"status": "fatal",
"metrics":
}
cbq> select * from system:indexes;
{
"requestID": "517b4cec-3909-45c1-b968-005f0ed65532",
"signature":
,
"results": [
{
"indexes":
}
],
"status": "success",
"metrics":
}
any user would be confused with the error message stating a requirement for a primary index when they use an aggregate function, INCLUDING, explain on a statement including the aggregate function.