Apache Cassandra™ 1.2

Configuring compression

Compression is enabled by default in Cassandra 1.1 and later.

Procedure

  1. Disable compression, using CQL to set the compression parameters to an empty string.
    CREATE TABLE DogTypes (
                  block_id uuid,
                  species text,
                  alias text,
                  population varint,
                  PRIMARY KEY (block_id)
                )
                WITH compression = { 'sstable_compression' : '' };
  2. Enable compression on an existing table, using ALTER TABLE to set the compression algorithm sstable_compression to LZ4Compressor (Cassandra 1.2.2 and later), SnappyCompressor, or DeflateCompressor.
    CREATE TABLE DogTypes (
                  block_id uuid,
                  species text,
                  alias text,
                  population varint,
                  PRIMARY KEY (block_id)
                )
                WITH compression = { 'sstable_compression' : 'LZ4Compressor' };
  3. Change compression on an existing table, using ALTER TABLE and setting the compression algorithm sstable_compression to DeflateCompressor.
    ALTER TABLE CatTypes
      WITH compression = { 'sstable_compression' : 'DeflateCompressor', 'chunk_length_kb' : 64 }
    You tune data compression on a per-table basis using CQL to alter a table.
Show/hide