Need to create an index on meta.id if you want to search key using Like

SQL++
1

CREATE INDEX idx_id ON B551((meta().id))

query

SELECT META().id FROM B551 t
where META().id LIKE “popm:%”

Any suggestion ?

2

CREATE PRIMARY index ON B551; will work, You should avoid creating primary index on production.

Instead of Secondary index on document key, You can create conditional Secondary index on document key, to avoid unnecessary intersect scans.

CREATE INDEX  `idx_id`  ON  `B551` ((meta(). `id` )) WHERE  META().id LIKE "popm:%";
SELECT META(t).id FROM B551  AS t
WHERE  META(t).id LIKE "popm:%"
3

I have created index like below

CREATE INDEX IDX_Cr_id ON B551((meta().id)) WHERE ((meta.id) like “Crp:%”)

And run the query

SELECT meta(t).id FROM B551 t
Where meta(t).id LIKE “Crp:%”

getting below error
msg": "No index available on keyspace B551

4

meta is function and missing ()

CREATE INDEX `IDX_Cr_id` ON `B551` ((meta(). `id` )) 
WHERE  META().id  LIKE  "Crp:%"