Details
-
Improvement
-
Resolution: Fixed
-
Major
-
6.6.3, 7.0.0, 7.1.0
-
1
Description
CREATE INDEX ix1 ON default(c1,c2,c3,c4) PARTITION BY HASH(c1,c3); |
|
SELECT COUNT(DISTINCT d.c2)
|
FROM default AS d |
WHERE d.c1 = 5 AND d.c3 = 7 AND d.c2 IS NOT NULL and d.c4 BETWEEN 10 AND 20; |
In above case HASH on c1,c3 AND equality predicate i.e. it will resolve single partition (All partition keys must be equality predicates), So treat this same as non partition index and apply same rules.
Attachments
For Gerrit Dashboard: MB-47568 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
158161,3 | MB-47568. Handle single partition in index aggregate pushdowns | master | query | Status: MERGED | +2 | +1 |
158182,2 | MB-47568. Handle single partition in index aggregate pushdowns | cheshire-cat | query | Status: MERGED | +2 | +1 |
158241,2 | MB-47568. spelling correction | master | query | Status: MERGED | +2 | +1 |
158242,2 | MB-47568. spelling correction | cheshire-cat | query | Status: MERGED | +2 | +1 |