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 updates the caching property:

ALTER MATERIALIZED VIEW cycling.cyclist_by_age 
WITH caching = { 
  'keys' : 'NONE', 
  'rows_per_partition' : '15'
};

Materialized views do not perform repair, so properties regarding repair are invalid.

Give Feedback