mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-05-22 07:50:38 +00:00
599f289f59
* feat: add `granularity` and `false_positive_rate` options for indexes Signed-off-by: Zhenchi <zhongzc_arch@outlook.com> * address comments Signed-off-by: Zhenchi <zhongzc_arch@outlook.com> * upgrade proto Signed-off-by: Zhenchi <zhongzc_arch@outlook.com> --------- Signed-off-by: Zhenchi <zhongzc_arch@outlook.com>
38 lines
2.1 KiB
Plaintext
38 lines
2.1 KiB
Plaintext
create table
|
|
skipping_table (
|
|
ts timestamp time index,
|
|
`id` string skipping index,
|
|
`name` string skipping index
|
|
with
|
|
(
|
|
granularity = 8192,
|
|
false_positive_rate = 0.05,
|
|
type = 'BLOOM',
|
|
),
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
show
|
|
create table
|
|
skipping_table;
|
|
|
|
+----------------+---------------------------------------------------------------------------------------------------------------+
|
|
| Table | Create Table |
|
|
+----------------+---------------------------------------------------------------------------------------------------------------+
|
|
| skipping_table | CREATE TABLE IF NOT EXISTS "skipping_table" ( |
|
|
| | "ts" TIMESTAMP(3) NOT NULL, |
|
|
| | "id" STRING NULL SKIPPING INDEX WITH(false_positive_rate = '0.01', granularity = '10240', type = 'BLOOM'), |
|
|
| | "name" STRING NULL SKIPPING INDEX WITH(false_positive_rate = '0.05', granularity = '8192', type = 'BLOOM'), |
|
|
| | TIME INDEX ("ts") |
|
|
| | ) |
|
|
| | |
|
|
| | ENGINE=mito |
|
|
| | |
|
|
+----------------+---------------------------------------------------------------------------------------------------------------+
|
|
|
|
drop table skipping_table;
|
|
|
|
Affected Rows: 0
|
|
|