Table attributes

Attributes per table.

The following attributes can be declared per table.

bloom_filter_fp_chance
See CQL properties in CQL for Cassandra 2.x.
bucket_high
See CQL Compaction Subproperties in CQL for Cassandra 2.x.
bucket_low
See CQL Compaction Subproperties in CQL for Cassandra 2.x.
caching
See CQL properties in CQL for Cassandra 2.x.
chunk_length_kb
See CQLCompression Subproperties in CQL for Cassandra 2.x.
column_metadata
(Default: N/A - container attribute) Column metadata defines these attributes of a column:
  • name: Binds a validation_class and (optionally) an index to a column.
  • validation_class: Type used to check the column value.
  • index_name: Name of the index.
  • index_type: Type of index. Currently the only supported value is KEYS.

Setting a value for the name option is required. The validation_class is set to the default_validation_class of the table if you do not set the validation_class option explicitly. The value of index_type must be set to create an index for a column. The value of index_name is not valid unless index_type is also set.

Setting and updating column metadata with the Cassandra-CLI utility requires a slightly different command syntax than other attributes; note the brackets and curly braces in this example:

[default@demo ] UPDATE COLUMN FAMILY users WITH  comparator =UTF8Type
AND  column_metadata =[{column_name: full_name, validation_class: UTF8Type, index_type: KEYS }];
column_type
(Default: Standard) The standard type of table contains regular columns.
comment
See CQL properties in CQL for Cassandra 2.x.
compaction_strategy
See compaction in CQL properties in CQL for Cassandra 2.x.
compaction_strategy_options
(Default: N/A - container attribute) Sets attributes related to the chosen compaction-strategy. Attributes are:
comparator
(Default: BytesType) Defines the data types used to validate and sort column names. There are several built-in column comparators available. The comparator cannot be changed after you create a table.
compression_options
(Default: N/A - container attribute) Sets the compression algorithm and sub-properties for the table. Choices are:
  • sstable_compression
  • chunk_length_kb
  • crc_check_chance
crc_check_chance
See CQLCompression Subproperties in CQL for Cassandra 2.x.
default_time_to_live
See CQL properties in CQL for Cassandra 2.x.
default_validation_class
(Default: N/A) Defines the data type used to validate column values. There are several built-in column validators available.
gc_grace
See CQL properties in CQL for Cassandra 2.x.
index_interval
See CQL properties in CQL for Cassandra 2.x.
key_validation_class
(Default: N/A) Defines the data type used to validate row key values. There are several built-in key validators available, however CounterColumnType (distributed counters) cannot be used as a row key validator.
max_compaction_threshold
See max_threshold in CQL Compaction Subproperties in CQL for Cassandra 2.x.
min_compaction_threshold
See min_threshold in CQL Compaction Subproperties in CQL for Cassandra 2.x.
max_index_interval
See CQL properties in CQL for Cassandra 2.x.
min_index_interval
See CQL properties in CQL for Cassandra 2.x.
memtable_flush_after_mins
Deprecated as of Cassandra 1.0, but can still be declared for backward compatibility. Use commitlog_total_space_in_mb.
memtable_flush_period_in_ms
See CQL properties in CQL for Cassandra 2.x.
memtable_operations_in_millions
Deprecated as of Cassandra 1.0, but can still be declared for backward compatibility. Use commitlog_total_space_in_mb.
memtable_throughput_in_mb
Deprecated as of Cassandra 1.0, but can still be declared for backward compatibility. Use commitlog_total_space_in_mb.
min_sstable_size
See CQL Compaction Subproperties in CQL for Cassandra 2.x.
name
(Default: N/A) Required. The user-defined name of the table.
read_repair_chance
See CQL properties in CQL for Cassandra 2.x.
speculative_retry
See CQL properties in CQL for Cassandra 2.x.
sstable_size_in_mb
See CQL Compaction Subproperties in CQL for Cassandra 2.x.
sstable_compression
See compression in CQL properties in CQL for Cassandra 2.x.
tombstone_compaction_interval
See CQL Compaction Subproperties in CQL for Cassandra 2.x.
tombstone_threshold
See CQL Compaction Subproperties in CQL for Cassandra 2.x.