Details
-
Improvement
-
Resolution: Unresolved
-
Critical
-
cbq-DP3, 4.5.0
-
Security Level: Public
Description
I built the index:
CREATE INDEX by_year ON bucket-1(year)
and tried to run the query:
SELECT DISTINCT year FROM bucket-1 LIMIT 20
which resulted in all docs scan:
https://gist.github.com/pavel-paulau/4da0f5e5cc37285e7265
https://gist.github.com/pavel-paulau/a7245ab7254c1b4fb53e
There are 20M documents and 15 unique years.
Attachments
Issue Links
- duplicates
-
MB-32408 DISTINCT doesn't push down
- Closed