Starting cqlsh on a search node

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

Procedure

  1. Determine which nodes in the cluster are running search:

    include:cycling-examples:example$dsetool_status.sh[]

    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
  2. For large datasets, increase the cqlsh timeout:

    export CQLSH_SEARCH_MANAGEMENT_TIMEOUT_SECONDS=900;
  3. 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>

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com