Alter a materialized view (MV)

Materialized views are created with the default table properties. Use the ALTER MATERIALIZED VIEW command to alter the view’s properties.

This command requires a keyspace, table, and a materialized view.

Specify updated properties and values in a WITH clause. The following example alters compression

ALTER MATERIALIZED VIEW cycling.cyclist_by_age
  WITH compression = {
    'sstable_compression' : 'DeflateCompressor',
    'chunk_length_kb' : 64
  }

For more information and examples, see the command reference for ALTER MATERIALIZED VIEW.

Give Feedback