Cassandra Query Language
Cassandra Query Language is a declarative, SQL-like language for defining schemas and querying and modifying data in Apache Cassandra-compatible systems.
ScyllaDB in Action
CQL is the Cassandra Query Language for defining, querying, and manipulating data in Cassandra-compatible databases.
- How it is used
- Uses CQL to define keyspaces and tables and to read, write, update, and delete clustered review data.
- How deep it goes
- Explains schema and CRUD statements through primary keys, partitions, replication settings, and coordinator-query consequences without detailing CQL grammar.
- Examples
- Demonstrates a food_reviews table, inserts for Ernie’s Eats and Really Good Ramen, and a partition-key DELETE.
- What you can do after
- Apply it via cqlsh to create a keyspace and table, write review rows, and delete rows using a partition key.
Read how ScyllaDB in Action explains Cassandra Query Language →
Spring in Action, Sixth Edition
CQL is Cassandra Query Language, the language for defining, querying, and modifying Cassandra data and schemas.
- How it is used
- Configures Cassandra keyspaces and inspects application data through cqlsh before Spring Data Cassandra persistence.
- How deep it goes
- Defines keyspace creation and table queries with working commands, but defers broader CQL syntax and replication details.
- Examples
- Uses the tacocloud keyspace and a tacos query returning embedded ingredient user-defined types.
- What you can do after
- Operate/configure Cassandra by creating a keyspace and querying persisted rows with cqlsh.
Read how Spring in Action, Sixth Edition explains Cassandra Query Language →
Related concepts
- CQL shellused by · The CQL shell is an interactive command-line client for connecting to Cassandra-compatible databases and executing Cassandra Query Language statements.
- cql protocolused by · The CQL protocol is the client-facing protocol for submitting Cassandra Query Language operations to a Cassandra-compatible database.
- deletionuses · Deletion is an operation that removes an item, association, or resource from a collection or system, or requests or marks it for removal.
- insertuses · An insertion is an operation that adds an element, record, or key-value association to a collection or data store, with placement and replacement behavior determined by the target.
- SQLcontrasts with · SQL is a standardized declarative language for defining, querying, and manipulating data and structures in relational database systems.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.