Altering a materialized view 

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

In DataStax Enterprise 5.0 and later, a materialized view has the default table properties. 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.


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' };