Description
USE 2 indexer nodes |
insert into default values("k01",{"fname":"xyz", "geneder":"M", "lname":"abc","company":"pqr"}); |
insert into default values("k02",{"fname":"xyz", "geneder":"M", "lname":"abc","company":"pqr"}); |
CREATE INDEX ix1 ON default (fname,geneder,META().id,lname) PARTITION BY HASH(META().id); |
SELECT lname FROM default WHERE fname IS VALUED ORDER BY fname, geneder, META().id; |
|
laname values returned is META().id
|
Attachments
Issue Links
For Gerrit Dashboard: MB-34136 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
108999,2 | MB-34136. Only retrivie required index keys from IndexScan | master | query | Status: MERGED | +2 | +1 |
109043,2 | MB-34136. Only retrivie required index keys from IndexScan | alice | query | Status: MERGED | +2 | +1 |
109044,1 | MB-34136. Only retrivie required index keys from IndexScan | vulcan | query | Status: ABANDONED | +2 | 0 |