Using scan_consistency in NQL Queries

Couchbase Server
1

Hi Team,

I want to use scan_consistency (request_plus) in NQL queries when we ran through cbq prompt. Could you please help me how we can achieve the same.

Thanks,
Debasis

2

It looks like specifying an option name prefixed with a hyphen is supposed to work.

3

\SET -scan_consistency request_plus ;

1 Like
4

@mreiche As you mentioned I had set the value but while checking the parameter value it is showing something different. Could you please how we can ensure whether the correct value set or not.

cbq> \SET -scan_consistency request_plus ;
cbq> EXPLAIN SELECT * FROM `config` LIMIT 1;
cbq> SELECT * FROM system:active_requests WHERE statement LIKE "%SELECT%";
{

"remoteAddr": "xx.xx.xx.xx:xxxx",
            "requestId": "260fe533-5a9e-4443-84bf-9f58b41546a8",
            "requestTime": "2025-03-02T06:41:41.09-05:00",
            "scanConsistency": "scan_plus",
            "state": "running",
            "statement": "SELECT * FROM system:active_requests WHERE statement LIKE \"%SELECT%\";",
            "statementType": "SELECT",
            "useCBO": true,

Thanks,
Debasis

5

request_plus in the client is translated to scan_plus. The behavior is correct.