Our spring boot app is using two buckets one is a Couchbase buckets and one Ephemeral bucket in the same cluster. Couchbase cache has a GSI index so I am able to write N1QL queries and get results. Since Ephemeral buckets only allow MOI index and the same cluster cannot have a GSI and MOI index I am unable to run N1Ql queries on the Ephemeral bucket.
The only query that actually fetches any data is a KV query findById(“125”). Another post on this forum suggested using “use key” but even though the query runs without errors it does not return any data.
SELECT * FROM
bkt_cpblending_ephemeral AS bkt USE KEYS ‘bkt.applicationId’ WHERE bkt.applicationId = ‘125’
Can anyone suggest how we can run N1QL queries on an Ephemeral bucket without creating an index?