Altering a materialized view

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

A materialized view has table properties like its source tables. Use the ALTER MATERIALIZED VIEW command 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.
cqlsh> ALTER MATERIALIZED VIEW cycling.cyclist_by_birthday
WITH caching = {'keys' : 'NONE', 'rows_per_partition' : '15' };