Reputation: 20088
When i try got get more then 5 lacks records im getting this error, i spent long time but the exception did not resolved., please help me the same.
And also i have tried from power bi same error throwing
Upvotes: 2
Views: 673
Reputation: 7414
USE covering index https://blog.couchbase.com/create-right-index-get-right-performance/
CREATE INDEX ix1 ON data_MY (owner, startDate, attributes.screen)
WHERE type_ = "Event";
SELECT owner, attributes.screen, DATE_FROMAT_STR(startDate, "1111-11-11") AS startDate
FROM data_MY
WHERE type_ = "Event" AND owner IS NOT MISSING;
Upvotes: 2