Altering table properties

Change the table properties after the table properties are defined or add table properties to a table with the ALTER TABLE command.

Use ALTER TABLE to add or change table properties.

Procedure

Alter a table to change the caching properties. See Enabling caching globally for more details.
ALTER TABLE cycling.comments 
WITH caching = {
  'keys' : 'NONE', 
  'rows_per_partition' : 10
};