Search code examples
cassandradatastaxcqlcassandra-2.1

How to modify System Keyspace (and its columnfamilies) in Cassandra

I am wondering if there is a workaround to ALTER the columnfamilies of System keyspace such as: schema_columns and schema_columnfamilies

I tried to type ALTER CQL in CQLSH and it returned

Unauthorized: Error from server: code=2100 [Unauthorized] message="system keyspace is not user-modifiable."

Is there a root-like account in cassandra that can help me modify System keyspace?

Solution

  • Modification to system keyspaces is not allowed.

    If using cassandra 3.x then try creating Materialized view on system keyspace tables for your requirement.