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. Specify updated properties and values in a WITH clause. Materialized views do not perform repair, so properties regarding repair are invalid.

Prerequisites

Keyspace exists
Table exists
MV exists

Alter a materialized view to change the caching properties.

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

Alter a materialized view (MV)

Prerequisites

Was this helpful?

Give Feedback