query-system-schema

EXPAND ON
SELECT * FROM system_schema.aggregates LIMIT 1;
EXPAND OFF;

SELECT * FROM system_schema.columns
  WHERE keyspace_name = 'cycling' AND table_name = 'cyclist_name';

SELECT * FROM system_traces.events;

EXPAND ON
SELECT * FROM system_schema.functions LIMIT 1;
EXPAND OFF;

SELECT id, keyspace_name, table_name FROM system_schema.tables
  WHERE keyspace_name = 'cycling' AND table_name = 'cyclist_name';

SELECT * FROM system_schema.keyspaces;

SELECT peer, data_center, dse_version, graph FROM system.peers;

EXPAND ON;
SELECT * FROM system_schema.tables
  WHERE keyspace_name = 'cycling' AND table_name = 'cyclist_name';
EXPAND OFF;

SELECT total - progress AS remaining FROM system_views.sstable_tasks;

EXPAND ON
SELECT * FROM system_schema.types LIMIT 1;
EXPAND OFF;

Give Feedback