The Cassandra DB contains the following table: metric.metric
What are the possible filters that can be used for the following table metric.metric?
cqlsh> SELECT * FROM metric.metric LIMIT 1; id | time | point ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- {path: 'first.node.threadpool.CACHE.monitored_idle', resolution: {precision: 3600, period: 31536000}} | 1586700000 | {max: 0, mean: 0, min: 0, sum: 0}
id={path: 'first.node.threadpool.CACHE.monitored_idle', resolution: {precision: 3600, period: 31536000}} time=1586700000 point={max: 0, mean: 0, min: 0, sum: 0}
Update: detailed schema
cqlsh> DESC SCHEMA CREATE KEYSPACE metric WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'} AND durable_writes = true; CREATE TYPE metric.metric_resolution ( precision int, period int ); CREATE TYPE metric.metric_id ( path text, resolution frozen<metric_resolution> ); CREATE TYPE metric.metric_point ( max double, mean double, min double, sum double ); CREATE TABLE metric.metric ( id frozen<metric_id>, time bigint, point frozen<metric_point>, PRIMARY KEY (id, time) ) WITH CLUSTERING ORDER BY (time ASC) AND ... CREATE TABLE metric.segment ( parent text, segment text, leaf boolean, length int, pos int, PRIMARY KEY (parent, segment) ) WITH CLUSTERING ORDER BY (segment ASC) AND ...