mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-05-16 13:00:40 +00:00
40 lines
792 B
SQL
40 lines
792 B
SQL
CREATE TABLE IF NOT EXISTS system_metrics (
|
|
host STRING,
|
|
idc STRING FULLTEXT,
|
|
cpu_util DOUBLE,
|
|
memory_util DOUBLE,
|
|
disk_util DOUBLE,
|
|
desc1 STRING,
|
|
desc2 STRING FULLTEXT,
|
|
desc3 STRING FULLTEXT,
|
|
ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY(host, idc),
|
|
INVERTED INDEX(idc, desc1, desc2),
|
|
TIME INDEX(ts)
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS test (
|
|
a STRING,
|
|
b STRING,
|
|
c DOUBLE,
|
|
ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY(a, b),
|
|
TIME INDEX(ts)
|
|
);
|
|
|
|
SHOW INDEX;
|
|
|
|
SHOW INDEX FROM test;
|
|
|
|
SHOW INDEX FROM system_metrics;
|
|
|
|
SHOW INDEX FROM system_metrics in public;
|
|
|
|
SHOW INDEX FROM system_metrics like '%util%';
|
|
|
|
SHOW INDEX FROM system_metrics WHERE Key_name = 'TIME INDEX';
|
|
|
|
DROP TABLE system_metrics;
|
|
|
|
DROP TABLE test;
|