NoSQL: Important System Tables of the Cassandra

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

In this post, I am sharing an important list of Cassandra System Tables.

Cassandra DBA can use these tables for a different investigation like, Schema information, Roles information, Tracing information and others.

There are different keyspaces are available like, system, system_auth, system_schema, system_traces.

system_auth Keyspace:

1 2	SELECT FROM system_auth.roles; SELECT FROM system_auth.role_permissions;

system_schema Keyspace:

SELECT *FROM system_schema.views;

SELECT *FROM system_schema.types;

SELECT *FROM system_schema.triggers;

SELECT *FROM system_schema.tables;

SELECT *FROM system_schema.keyspaces;

SELECT *FROM system_schema.indexes;

SELECT *FROM system_schema.functions;

SELECT *FROM system_schema.columns;

SELECT *FROM system_schema.dropped_columns;

SELECT *FROM system_schema.aggregates;

system_traces Keyspace:

1 2	SELECT FROM system_traces.sessions; SELECT FROM system_traces.events;

system Keyspace:

SELECT *FROM system.available_ranges;

SELECT *FROM system.peers;

SELECT *FROM system.peer_events;

SELECT *FROM system.batchlog;

SELECT *FROM system.batches;

Jul 29, 2016Anvesh Patel