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 and configuring caching for more details.
ALTER TABLE cycling.comments WITH caching = { 'keys' : 'NONE', 'rows_per_partition' : 10 };