Can I do N1QL query with only view index ?
This post said "It is the basic requirement to be able to use the query language on your data"
.
This post said it’s not.
Here’re my sql list:
//create view index
CREATE INDEX idx_tp_app_mt ON default(tp,app,mt) WHERE tbl == 'dv';
//query on view index
EXPLAIN SELECT * FROM default USE INDEX(idx_tp_app_mt USING VIEW)WHERE tp = 'i'
When I try query with only one view index. the server returns
[
{
"code": 4000,
"msg": "No primary index on keyspace default. Use CREATE PRIMARY INDEX to create one."
}
]
What I need is doing N1QL query without primary index (it use too much resource).
Thanks