Apache Cassandra

  1. Cassandra Query Language
    1. Introduction to CQL Shell
      1. Connecting to a Cluster
        1. Local Connections
          1. Remote Connections
            1. Authentication
            2. Basic Commands
              1. Help System
                1. Command History
                  1. Output Formatting
                  2. Query Execution
                    1. Statement Termination
                      1. Batch Execution
                        1. Error Handling
                        2. Configuration Options
                          1. Connection Settings
                            1. Display Options
                          2. Data Definition Language
                            1. CREATE KEYSPACE
                              1. Syntax and Options
                                1. Replication Configuration
                                  1. Durable Writes
                                  2. USE
                                    1. Switching Keyspaces
                                      1. Current Keyspace Context
                                      2. CREATE TABLE
                                        1. Defining Schema
                                          1. Primary Key Specification
                                            1. Table Options
                                              1. Compression Settings
                                                1. Compaction Settings
                                                2. ALTER TABLE
                                                  1. Adding Columns
                                                    1. Dropping Columns
                                                      1. Modifying Table Properties
                                                        1. Changing Column Types
                                                        2. DROP KEYSPACE
                                                          1. Data Deletion
                                                            1. Cascade Effects
                                                            2. DROP TABLE
                                                              1. Table Removal
                                                                1. Data Loss Implications
                                                                2. CREATE TYPE
                                                                  1. UDT Definition
                                                                    1. Field Specification
                                                                    2. ALTER TYPE
                                                                      1. Adding Fields
                                                                        1. Renaming Fields
                                                                        2. DROP TYPE
                                                                          1. Type Removal
                                                                            1. Dependency Checking
                                                                            2. CREATE INDEX
                                                                              1. Index Creation
                                                                                1. Index Options
                                                                                2. DROP INDEX
                                                                                  1. Index Removal
                                                                                3. Data Manipulation Language
                                                                                  1. INSERT
                                                                                    1. Syntax and Usage
                                                                                      1. Value Specification
                                                                                        1. TTL Setting
                                                                                          1. Timestamp Setting
                                                                                          2. UPDATE
                                                                                            1. Updating Rows
                                                                                              1. Conditional Updates
                                                                                                1. Collection Updates
                                                                                                  1. Counter Updates
                                                                                                  2. SELECT
                                                                                                    1. Basic Query Syntax
                                                                                                      1. Column Selection
                                                                                                        1. The WHERE Clause
                                                                                                          1. Partition Key Restrictions
                                                                                                            1. Clustering Key Restrictions
                                                                                                              1. Secondary Index Queries
                                                                                                              2. Filtering with ALLOW FILTERING
                                                                                                                1. The IN Clause
                                                                                                                  1. The LIMIT Clause
                                                                                                                    1. The ORDER BY Clause
                                                                                                                      1. The GROUP BY Clause
                                                                                                                      2. DELETE
                                                                                                                        1. Deleting Rows
                                                                                                                          1. Deleting Columns
                                                                                                                            1. Conditional Deletes
                                                                                                                              1. Collection Element Deletion
                                                                                                                              2. BATCH Statements
                                                                                                                                1. Atomic Batches
                                                                                                                                  1. Unlogged Batches
                                                                                                                                    1. Counter Batches
                                                                                                                                      1. Batch Limitations
                                                                                                                                        1. Performance Considerations
                                                                                                                                      2. Advanced CQL Features
                                                                                                                                        1. Functions
                                                                                                                                          1. Aggregate Functions
                                                                                                                                            1. COUNT
                                                                                                                                              1. MIN
                                                                                                                                                1. MAX
                                                                                                                                                  1. SUM
                                                                                                                                                    1. AVG
                                                                                                                                                    2. Scalar Functions
                                                                                                                                                      1. token
                                                                                                                                                        1. now
                                                                                                                                                          1. uuid
                                                                                                                                                            1. timeuuid
                                                                                                                                                              1. toDate
                                                                                                                                                                1. toTimestamp
                                                                                                                                                                  1. toUnixTimestamp
                                                                                                                                                                    1. dateOf
                                                                                                                                                                      1. unixTimestampOf
                                                                                                                                                                        1. minTimeuuid
                                                                                                                                                                          1. maxTimeuuid
                                                                                                                                                                          2. User-Defined Functions
                                                                                                                                                                            1. Creating UDFs
                                                                                                                                                                              1. Language Support
                                                                                                                                                                                1. Security Considerations
                                                                                                                                                                                2. User-Defined Aggregates
                                                                                                                                                                                  1. Creating UDAs
                                                                                                                                                                                    1. State Functions
                                                                                                                                                                                      1. Final Functions
                                                                                                                                                                                    2. Lightweight Transactions
                                                                                                                                                                                      1. The IF Clause
                                                                                                                                                                                        1. Compare-and-Set Operations
                                                                                                                                                                                          1. IF NOT EXISTS
                                                                                                                                                                                            1. IF EXISTS
                                                                                                                                                                                              1. Use Cases and Limitations
                                                                                                                                                                                                1. Performance Impact
                                                                                                                                                                                                2. Paging
                                                                                                                                                                                                  1. Paging Large Result Sets
                                                                                                                                                                                                    1. Page Size Configuration
                                                                                                                                                                                                      1. Token-Based Paging
                                                                                                                                                                                                      2. JSON Support
                                                                                                                                                                                                        1. JSON Functions
                                                                                                                                                                                                          1. fromJson Function
                                                                                                                                                                                                            1. toJson Function
                                                                                                                                                                                                              1. JSON Inserts
                                                                                                                                                                                                                1. JSON Selects
                                                                                                                                                                                                                2. Prepared Statements
                                                                                                                                                                                                                  1. Statement Preparation
                                                                                                                                                                                                                    1. Parameter Binding
                                                                                                                                                                                                                      1. Performance Benefits

                                                                                                                                                                                                                  Previous

                                                                                                                                                                                                                  5. Data Modeling in Cassandra

                                                                                                                                                                                                                  Go to top

                                                                                                                                                                                                                  Next

                                                                                                                                                                                                                  7. Setting Up and Configuring a Cassandra Cluster