NAME

cbc query - perform N1QL query.

SYNOPSIS

cbc query [options] <statement>...
cbc query [options] --param=NAME=VALUE... <statement>...
cbc query [options] --raw=NAME=VALUE... <statement>...
cbc query (-h|--help)

DESCRIPTION

Execute one or more N1QL queries and print results to standard output.

OPTIONS

-h|--help: Show this screen.
--param=NAME=VALUE: Parameters for the query. Without '=' sign value will be treated as positional parameter.
--prepare: Prepare statement.
--read-only: Mark query as read only. Any mutations will fail.
--preserve-expiry: Ensure that expiry will be preserved after mutations.
--disable-metrics: Do not request metrics.
--profile=MODE: Request the service to profile the query and return report (allowed values: off, phases, timings).
--bucket-name=STRING: Name of the bucket where the scope is defined (see –scope-name).
--scope-name=STRING: Name of the scope.
--client-context-id=STRING: Override client context ID for the query(-ies).
--flex-index: Tell query service to utilize flex index (full text search).
--maximum-parallelism=INTEGER: Parallelism for query execution (0 to disable).
--scan-cap=INTEGER: Maximum buffer size between indexer and query service.
--scan-wait=DURATION: How long query engine will wait for indexer to catch up on scan consistency.
--scan-consistency=MODE: Set consistency guarantees for the query (allowed values: not_bounded, request_plus).
--pipeline-batch=INTEGER: Number of items execution operators can batch for fetch from the Key/Value service.
--pipeline-cap=INTEGER: Maximum number of items each execution operator can buffer between various operators.
--raw=NAME=VALUE: Set any query option for the query. Read the documentation: https://docs.couchbase.com/server/current/n1ql/n1ql-rest-api.
--json-lines: Use JSON Lines format (https://jsonlines.org) to print results.

LOGGER OPTIONS

--log-level=LEVEL: Log level (allowed values are: trace, debug, info, warning, error, critical, off). [default: off]
--log-output=PATH: File to send logs (when is not set, logs will be written to STDERR).
--log-protocol=PATH: File to send protocol logs.

CONNECTION OPTIONS

--connection-string=STRING: Connection string for the cluster. [default: couchbase://localhost]
--username=STRING: Username for the cluster. [default: Administrator]
--password=STRING: Password for the cluster. [default: password]
--certificate-path=STRING: Path to the certificate.
--key-path=STRING: Path to the key.
--ldap-compatible: Whether to select authentication mechanism that is compatible with LDAP.
--configuration-profile=STRING: Apply configuration profile (might override other switches). (available profiles: wan_development)

SECURITY OPTIONS

--disable-tls: Whether to disable TLS.
--trust-certificate-path=STRING: Path to the trust certificate bundle.
--tls-verify-mode=MODE: Path to the certificate (allowed values: peer, none). [default: peer]

TIMEOUT OPTIONS

--bootstrap-timeout=DURATION: Timeout for overall bootstrap of the SDK. [default: 10000ms]
--connect-timeout=DURATION: Timeout for socket connection. [default: 10000ms]
--resolve-timeout=DURATION: Timeout to resolve DNS address for the sockets. [default: 2000ms]
--key-value-timeout=DURATION: Timeout for Key/Value operations. [default: 2500ms]
--key-value-durable-timeout=DURATION: Timeout for Key/Value durable operations. [default: 10000ms]
--query-timeout=DURATION: Timeout for Query service. [default: 75000ms]
--search-timeout=DURATION: Timeout for Search service. [default: 75000ms]
--eventing-timeout=DURATION: Timeout for Eventing service. [default: 75000ms]
--analytics-timeout=DURATION: Timeout for Analytics service. [default: 75000ms]
--view-timeout=DURATION: Timeout for View service. [default: 75000ms]
--management-timeout=DURATION: Timeout for management operations. [default: 75000ms]

COMPRESSION OPTIONS

--disable-compression: Whether to disable compression.
--compression-minimum-size=INTEGER: The minimum size of the document (in bytes), that will be compressed. [default: 32]
--compression-minimum-ratio=FLOAT: The minimum compression ratio to allow compressed form to be used. [default: 0.83]

DNS-SRV OPTIONS

--dns-srv-timeout=DURATION: Timeout for DNS SRV requests. [default: 500ms]
--dns-srv-nameserver=STRING: Hostname of the DNS server where the DNS SRV requests will be sent.
--dns-srv-port=INTEGER: Port of the DNS server where the DNS SRV requests will be sent.

NETWORK OPTIONS

--tcp-keep-alive-interval=DURATION: Interval for TCP keep alive. [default: 60000ms]
--config-poll-interval=DURATION: How often the library should poll for new configuration. [default: 2500ms]
--idle-http-connection-timeout=DURATION: Period to wait before calling HTTP connection idle. [default: 4500ms]

TRANSACTIONS OPTIONS

--transactions-durability-level=LEVEL: Durability level of the transaction (allowed values: none, majority, majority_and_persist_to_active, persist_to_majority). [default: majority]
--transactions-timeout=DURATION: Timeout of the transaction. [default: 15000ms]
--transactions-metadata-bucket=STRING: Bucket name where transaction metadata is stored.
--transactions-metadata-scope=STRING: Scope name where transaction metadata is stored. [default: _default]
--transactions-metadata-collection=STRING: Collection name where transaction metadata is stored. [default: _default]
--transactions-query-scan-consistency=MODE: Scan consistency for queries in transactions (allowed values: not_bounded, request_plus). [default: request_plus]
--transactions-cleanup-ignore-lost-attempts: Do not cleanup lost attempts.
--transactions-cleanup-ignore-client-attempts: Do not cleanup client attempts.
--transactions-cleanup-window=DURATION: Cleanup window. [default: 60000ms]

METRICS OPTIONS

--disable-metrics: Disable collecting and reporting metrics.
--metrics-emit-interval=DURATION: Interval to emit metrics report on INFO log level. [default: 600000ms]

TRACING OPTIONS

--disable-tracing: Disable collecting and reporting trace information.
--tracing-orphaned-emit-interval=DURATION: Interval to emit report about orphan operations. [default: 10000ms]
--tracing-orphaned-sample-size=INTEGER: Size of the sample of the orphan report. [default: 64]
--tracing-threshold-emit-interval=DURATION: Interval to emit report about operations exceeding threshold. [default: 10000ms]
--tracing-threshold-sample-size=INTEGER: Size of the sample of the threshold report. [default: 64]
--tracing-threshold-key-value=DURATION: Threshold for Key/Value service. [default: 500ms]
--tracing-threshold-query=DURATION: Threshold for Query service. [default: 1000ms]
--tracing-threshold-search=DURATION: Threshold for Search service. [default: 1000ms]
--tracing-threshold-analytics=DURATION: Threshold for Analytics service. [default: 1000ms]
--tracing-threshold-management=DURATION: Threshold for Management operations. [default: 1000ms]
--tracing-threshold-eventing=DURATION: Threshold for Eventing service. [default: 1000ms]
--tracing-threshold-view=DURATION: Threshold for View service. [default: 1000ms]

BEHAVIOR OPTIONS

--user-agent-extra=STRING: Append extra string SDK identifiers. [default: cbc].
--network=STRING: Network (a.k.a. Alternate Addresses) to use. [default: auto]
--show-queries: Log queries on INFO level.
--enable-clustermap-notifications: Allow server to send notifications when cluster configuration changes.
--disable-mutation-tokens: Do not request Key/Value service to send mutation tokens.
--disable-unordered-execution: Disable unordered execution for Key/Value service.

ENVIRONMENT

CBC_LOG_LEVEL: Overrides default value for --log-level.
CBC_CONNECTION_STRING: Overrides default value for --connection-string.
CBC_USERNAME: Overrides default value for --username.
CBC_PASSWORD: Overrides default value for --password.

EXAMPLES

Query with positional parameters:

cbc query --param 1 --param 2 'SELECT $1 + $2'

Query with named parameters:

cbc query --param a=1 --param b=2 'SELECT $a + $b'