Details
-
Improvement
-
Resolution: Fixed
-
Critical
-
cbq-DP4, 4.0.0
-
Security Level: Public
Description
query is
select count(VMs) FROM default
index on VMs is created
cbq> create index a1 on default(VMs);
{
"request_id": "031c4c4a-e874-485b-ab3c-ee3453f84d11",
"signature": null,
"results": [
],
"status": "success",
"metrics":
}
cbq> select * from system:indexes;
{
"request_id": "6c3159fe-5dfc-4a58-b65c-720efa71209b",
"signature":
,
"results": [
{
"indexes":
},
cbq> EXPLAIN SELECT count(VMs) FROM default;
{
"request_id": "5909a400-7b1a-4b54-a058-a90ef8b86de9",
"signature": "json",
"results": [
{
"#operator": "Sequence",
"~children": [
,
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
,
,
{ "#operator": "IntermediateGroup", "aggregates": [ "count((`default`.`VMs`))" ], "group_keys": [] } ]
}
},
,
,
{
"#operator": "Parallel",
"~child": {
"#operator": "Sequence",
"~children": [
{
"#operator": "InitialProject",
"result_terms": [
]
},
]
}
}
]
}
],
"status": "success",
"metrics":
}
cbq>