mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-06-03 05:40:40 +00:00
19 lines
1.7 KiB
Plaintext
19 lines
1.7 KiB
Plaintext
SHOW CREATE TABLE granularity_and_false_positive_rate;
|
|
|
|
+-------------------------------------+--------------------------------------------------------------------+
|
|
| Table | Create Table |
|
|
+-------------------------------------+--------------------------------------------------------------------+
|
|
| granularity_and_false_positive_rate | CREATE TABLE IF NOT EXISTS "granularity_and_false_positive_rate" ( |
|
|
| | "ts" TIMESTAMP(3) NOT NULL, |
|
|
| | "val" DOUBLE NULL, |
|
|
| | TIME INDEX ("ts") |
|
|
| | ) |
|
|
| | |
|
|
| | ENGINE=mito |
|
|
| | WITH( |
|
|
| | 'index.false_positive_rate' = '0.01', |
|
|
| | 'index.granularity' = '8192' |
|
|
| | ) |
|
|
+-------------------------------------+--------------------------------------------------------------------+
|
|
|