Starting cqlsh on a search node

Connect to a search node to use CQL search management commands.

Procedure

Determine which nodes in the cluster are running search:

include:cycling-examples:example$dsetool-status.sh[tag=dsetool-status]

DSE Search operations are available only on search-enabled nodes. DataStax recommends single workload datacenters.

The following example shows a development environment where all nodes in the cluster are in the same physical location, on the same rack, and the nodes have been separated into datacenters based on their workloads.

DC: Main       Workload: Cassandra       Graph: no
======================================================
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
--   Address          Load           Owns                 VNodes              Rack         Health [0,1]
UN   10.10.10.111   15.51 MiB        ?                    32                  rack1        0.90
UN   10.10.10.113   19.51 MiB        ?                    32                  rack1        0.90

DC: Search            Workload: Search          Graph: no
======================================================
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
--   Address          Load           Owns                 VNodes              Rack         Health [0,1]
UN   10.10.10.108   18.13 MiB        ?                    32                  rack1        0.90
UN   10.10.10.110   17.4 MiB         ?                    32                  rack1        0.90

For large datasets, increase the cqlsh timeout:

export CQLSH_SEARCH_MANAGEMENT_TIMEOUT_SECONDS=900;

Launch a cqlsh session on a search node:

cqlsh hostname

A CQL sessions starts on the remote host.

Connected to cluster1 at 10.10.10.108:9042.
[cqlsh 5.0.1 | Cassandra 3.11.0.1805 | DSE 5.1.3 | CQL spec 3.4.4 | Native protocol v4]
Use HELP for help.
cqlsh>

Starting cqlsh on a search node

Procedure

Was this helpful?

Give Feedback