Access data using CQL

Common ways to access data using CQL are:

  • CQL shell (cqlsh): A Python-based command line shell to access the database and issue CQL (Cassandra Query Language) commands

    In a production database, executing statements programmatically (with a driver) is more practical than using cqlsh, but cqlsh can be a convenient way to test statements in development.

  • DataStax-compatible drivers: The primary resource for application developers to connect to database clusters programmatically

Schema changes, which involve CREATE, ALTER, and DROP statements, are not safe for concurrent use. Performing more than one change in flight has a high probability of causing irreconcilable conflicts, with nodes in the cluster using different schema "versions" indefinitely.

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2025 DataStax, an IBM Company | Privacy policy | Terms of use | Manage Privacy Choices

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