Altering a materialized view

Alter the properties of a materialized view with the ALTER MATERIALIZED VIEW command.

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.

Procedure

Alter a materialized view to change the caching properties.

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