HOME
ACADEMY
DOCS
CONTACT US
DOWNLOAD DATASTAX
GLOSSARY
SUPPORT
DEVELOPER BLOGS
This document is
no longer maintained
.
CQL for Apache Cassandra 2.0 & 2.1
(Not supported)
Introduction to Cassandra Query Language
CQL data modeling
Data Modeling Concepts
Data modeling example
Example of a music service
Compound keys and clustering
Collection columns
Adding a collection to a table
Updating a collection
Indexing a collection
Filtering data in a collection
When to use a collection
Indexing
When to use an index
Using an index
Using multiple indexes
Building and maintaining indexes
Working with legacy applications
Using a CQL query
Using CQL
Starting cqlsh
Starting cqlsh on Linux
Starting cqlsh on Windows
Using tab completion
Creating and updating a keyspace
Example of creating a keyspace
Updating the replication factor
Creating a table
Using a compound primary key
Inserting data into a table
Using a user-defined type
Querying a system table
Keyspace, table, and column information
Cluster information
Retrieving and sorting results
Retrieval using the IN keyword
Slicing over partition rows
Batching conditional updates to a static column
Using and misusing batches
Using the keyspace qualifier
Adding columns to a table
Expiring data
Expiring data example
Determining time-to-live for a column
Removing a keyspace, schema, or data
Dropping a table or keyspace
Deleting columns and rows
Determining the date/time of a write
Altering the data type of a column
Using collections
Using the set type
Using the list type
Using the map type
Indexing a column
Using lightweight transactions
Paging through unordered partitioner results
Using a counter
Tracing consistency changes
Setup to trace consistency changes
Trace reads at different consistency levels
How consistency affects performance
CQL reference
Introduction
CQL lexical structure
Uppercase and lowercase
Escaping characters
Valid literals
Exponential notation
CQL code comments
CQL Keywords
CQL data types
Blob type
Collection type
Counter type
UUID and timeuuid types
uuid and Timeuuid functions
Timestamp type
Tuple type
User-defined type
CQL keyspace and table properties
Table properties
Compaction subproperties
Compression subproperties
Functions
CQL limits
cqlsh commands
cqlsh
The cqlshrc file
CAPTURE
CONSISTENCY
COPY
DESCRIBE
EXPAND
EXIT
PAGING
SHOW
SOURCE
TRACING
CQL commands
ALTER KEYSPACE
ALTER TABLE
ALTER TYPE
ALTER USER
BATCH
CREATE INDEX
CREATE KEYSPACE
CREATE TABLE
CREATE TRIGGER
CREATE TYPE
CREATE USER
DELETE
DROP INDEX
DROP KEYSPACE
DROP TABLE
DROP TRIGGER
DROP TYPE
DROP USER
GRANT
INSERT
LIST PERMISSIONS
LIST USERS
REVOKE
SELECT
TRUNCATE
UPDATE
USE
Home
Academy
Docs home
Contact us
Download DataStax
Glossary
Support
Developer blogs
Search
Home
CQL reference
CQL commands
CQL commands
CQL commands.
ALTER KEYSPACE
Change property values of a keyspace.
ALTER TABLE
Modify the column metadata of a table.
ALTER TYPE
Modify a user-defined type. Apache Cassandra™ 2.1 and later.
ALTER USER
Alter existing user options.
BATCH
Write multiple DML statements.
CREATE INDEX
Define a new index on a single column of a table.
CREATE KEYSPACE
Define a new keyspace and its replica placement strategy.
CREATE TABLE
Define a new table.
CREATE TRIGGER
Registers a trigger on a table.
CREATE TYPE
Create a user-defined type. Apache Cassandra 2.1 and later.
CREATE USER
Create a new user.
DELETE
Removes entire rows or one or more columns from one or more rows.
DROP INDEX
Drop the named index.
DROP KEYSPACE
Remove the keyspace.
DROP TABLE
Remove the named table.
DROP TRIGGER
Removes registration of a trigger.
DROP TYPE
Drop a user-defined type. Apache Cassandra 2.1 and later.
DROP USER
Remove a user.
GRANT
Provide access to database objects.
INSERT
Add or update columns.
LIST PERMISSIONS
List permissions granted to a user.
LIST USERS
List existing users and their superuser status.
REVOKE
Revoke user permissions.
SELECT
Retrieve data from a Cassandra table.
TRUNCATE
Remove all data from a table.
UPDATE
Update columns in a row.
USE
Connect the client session to a keyspace.
CQL reference
Introduction
CQL lexical structure
CQL data types
CQL keyspace and table properties
Functions
CQL limits
cqlsh commands
CQL commands
ALTER KEYSPACE
ALTER TABLE
ALTER TYPE
ALTER USER
BATCH
CREATE INDEX
CREATE KEYSPACE
CREATE TABLE
CREATE TRIGGER
CREATE TYPE
CREATE USER
DELETE
DROP INDEX
DROP KEYSPACE
DROP TABLE
DROP TRIGGER
DROP TYPE
DROP USER
GRANT
INSERT
LIST PERMISSIONS
LIST USERS
REVOKE
SELECT
TRUNCATE
UPDATE
USE
