Apache Cassandra

6.

Cassandra Query Language

6.1.

Introduction to CQL Shell

6.1.1.

Connecting to a Cluster

6.1.1.1.

Local Connections

6.1.1.2.

Remote Connections

6.1.1.3.

6.1.2.

6.1.2.1.

6.1.2.2.

Command History

6.1.2.3.

Output Formatting

6.1.3.

Query Execution

6.1.3.1.

Statement Termination

6.1.3.2.

Batch Execution

6.1.3.3.

6.1.4.

Configuration Options

6.1.4.1.

Connection Settings

6.1.4.2.

Display Options

6.2.

Data Definition Language

6.2.1.

CREATE KEYSPACE

6.2.1.1.

Syntax and Options

6.2.1.2.

Replication Configuration

6.2.1.3.

6.2.2.

6.2.2.1.

Switching Keyspaces

6.2.2.2.

Current Keyspace Context

6.2.3.

6.2.3.1.

Defining Schema

6.2.3.2.

Primary Key Specification

6.2.3.3.

6.2.3.4.

Compression Settings

6.2.3.5.

Compaction Settings

6.2.4.

6.2.4.1.

6.2.4.2.

Dropping Columns

6.2.4.3.

Modifying Table Properties

6.2.4.4.

Changing Column Types

6.2.5.

6.2.5.1.

6.2.5.2.

Cascade Effects

6.2.6.

6.2.6.1.

6.2.6.2.

Data Loss Implications

6.2.7.

6.2.7.1.

6.2.7.2.

Field Specification

6.2.8.

6.2.8.1.

6.2.8.2.

Renaming Fields

6.2.9.

6.2.9.1.

6.2.9.2.

Dependency Checking

6.2.10.

6.2.10.1.

6.2.10.2.

6.2.11.

6.2.11.1.

6.3.

Data Manipulation Language

6.3.1.

6.3.1.1.

Syntax and Usage

6.3.1.2.

Value Specification

6.3.1.3.

6.3.1.4.

Timestamp Setting

6.3.2.

6.3.2.1.

6.3.2.2.

Conditional Updates

6.3.2.3.

Collection Updates

6.3.2.4.

Counter Updates

6.3.3.

6.3.3.1.

Basic Query Syntax

6.3.3.2.

Column Selection

6.3.3.3.

The WHERE Clause

6.3.3.3.1.

Partition Key Restrictions

6.3.3.3.2.

Clustering Key Restrictions

6.3.3.3.3.

Secondary Index Queries

6.3.3.4.

Filtering with ALLOW FILTERING

6.3.3.5.

6.3.3.6.

The LIMIT Clause

6.3.3.7.

The ORDER BY Clause

6.3.3.8.

The GROUP BY Clause

6.3.4.

6.3.4.1.

6.3.4.2.

Deleting Columns

6.3.4.3.

Conditional Deletes

6.3.4.4.

Collection Element Deletion

6.3.5.

BATCH Statements

6.3.5.1.

6.3.5.2.

Unlogged Batches

6.3.5.3.

Counter Batches

6.3.5.4.

Batch Limitations

6.3.5.5.

Performance Considerations

6.4.

Advanced CQL Features

6.4.1.

6.4.1.1.

Aggregate Functions

6.4.1.1.1.

6.4.1.1.2.

6.4.1.1.3.

6.4.1.1.4.

6.4.1.1.5.

6.4.1.2.

Scalar Functions

6.4.1.2.1.

6.4.1.2.2.

6.4.1.2.3.

6.4.1.2.4.

6.4.1.2.5.

6.4.1.2.6.

6.4.1.2.7.

toUnixTimestamp

6.4.1.2.8.

6.4.1.2.9.

unixTimestampOf

6.4.1.2.10.

6.4.1.2.11.

6.4.1.3.

User-Defined Functions

6.4.1.3.1.

6.4.1.3.2.

Language Support

6.4.1.3.3.

Security Considerations

6.4.1.4.

User-Defined Aggregates

6.4.1.4.1.

6.4.1.4.2.

State Functions

6.4.1.4.3.

Final Functions

6.4.2.

Lightweight Transactions

6.4.2.1.

6.4.2.2.

Compare-and-Set Operations

6.4.2.3.

6.4.2.4.

6.4.2.5.

Use Cases and Limitations

6.4.2.6.

Performance Impact

6.4.3.

6.4.3.1.

Paging Large Result Sets

6.4.3.2.

Page Size Configuration

6.4.3.3.

Token-Based Paging

6.4.4.

6.4.4.1.

6.4.4.2.

fromJson Function

6.4.4.3.

toJson Function

6.4.4.4.

6.4.4.5.

6.4.5.

Prepared Statements

6.4.5.1.

Statement Preparation

6.4.5.2.

Parameter Binding

6.4.5.3.

Performance Benefits

Previous

5. Data Modeling in Cassandra

Go to top

Next

7. Setting Up and Configuring a Cassandra Cluster