Details
-
Improvement
-
Resolution: Fixed
-
Major
-
6.5.1
-
CX Sprint 219, CX Sprint 220, CX Sprint 221, CX Sprint 222, CX Sprint 223, CX Sprint 248, CX Sprint 249, CX Sprint 250, CX Sprint 251, CX Sprint 252, CX Sprint 253, CX Sprint 254, CX Sprint 255, CX Sprint 256, CX Sprint 257, CX Sprint 258, CX Sprint 259
Description
Composite secondary index is currently not chosen by the query optimizer if the predicate does not include all indexed fields.
E.g.
CREATE DATASET breweries ON `beer-sample` WHERE `type` = "brewery";
|
CREATE INDEX idx_country_state ON breweries(country:string, state:string);
|
Query:
SELECT *
|
FROM breweries
|
WHERE country = 'United States';
|
The above secondary index is currently not used because the WHERE clause does not include predicate on the 'state' field.
Attachments
Issue Links
For Gerrit Dashboard: MB-38319 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
156508,6 | MB-38319: Update test cases for storing NULLs in secondary indexes | master | cbas-core | Status: MERGED | +2 | +1 |
157051,4 | MB-38319: Enable secondary indexes on prefixes | master | cbas-core | Status: MERGED | +2 | +1 |
158876,3 | MB-38319: Adapt backup/restore for unknown key option | master | cbas-core | Status: MERGED | +2 | +1 |
159069,8 | MB-38319: Add more tests for prefix search | master | cbas-core | Status: MERGED | +2 | +1 |
159159,2 | MB-38319: Refactor OptionalBoolean | master | cbas-core | Status: MERGED | +2 | +1 |