mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-05-15 20:40:39 +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>
102 lines
7.9 KiB
Plaintext
102 lines
7.9 KiB
Plaintext
CREATE TABLE log (
|
|
ts TIMESTAMP TIME INDEX,
|
|
msg STRING FULLTEXT INDEX,
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
SHOW CREATE TABLE log;
|
|
|
|
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
| Table | Create Table |
|
|
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
| log | CREATE TABLE IF NOT EXISTS "log" ( |
|
|
| | "ts" TIMESTAMP(3) NOT NULL, |
|
|
| | "msg" STRING NULL FULLTEXT INDEX WITH(analyzer = 'English', backend = 'bloom', case_sensitive = 'false', false_positive_rate = '0.01', granularity = '10240'), |
|
|
| | TIME INDEX ("ts") |
|
|
| | ) |
|
|
| | |
|
|
| | ENGINE=mito |
|
|
| | |
|
|
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
|
|
DROP TABLE log;
|
|
|
|
Affected Rows: 0
|
|
|
|
CREATE TABLE log_with_opts (
|
|
ts TIMESTAMP TIME INDEX,
|
|
msg TEXT FULLTEXT INDEX WITH (analyzer='English', case_sensitive='true'),
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
SHOW CREATE TABLE log_with_opts;
|
|
|
|
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
| Table | Create Table |
|
|
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
| log_with_opts | CREATE TABLE IF NOT EXISTS "log_with_opts" ( |
|
|
| | "ts" TIMESTAMP(3) NOT NULL, |
|
|
| | "msg" STRING NULL FULLTEXT INDEX WITH(analyzer = 'English', backend = 'bloom', case_sensitive = 'true', false_positive_rate = '0.01', granularity = '10240'), |
|
|
| | TIME INDEX ("ts") |
|
|
| | ) |
|
|
| | |
|
|
| | ENGINE=mito |
|
|
| | |
|
|
+---------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
|
|
DROP TABLE log_with_opts;
|
|
|
|
Affected Rows: 0
|
|
|
|
CREATE TABLE log_multi_fulltext_cols (
|
|
ts TIMESTAMP TIME INDEX,
|
|
msg TINYTEXT FULLTEXT INDEX,
|
|
msg2 VARCHAR FULLTEXT INDEX,
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
SHOW CREATE TABLE log_multi_fulltext_cols;
|
|
|
|
+-------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
| Table | Create Table |
|
|
+-------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
| log_multi_fulltext_cols | CREATE TABLE IF NOT EXISTS "log_multi_fulltext_cols" ( |
|
|
| | "ts" TIMESTAMP(3) NOT NULL, |
|
|
| | "msg" STRING NULL FULLTEXT INDEX WITH(analyzer = 'English', backend = 'bloom', case_sensitive = 'false', false_positive_rate = '0.01', granularity = '10240'), |
|
|
| | "msg2" STRING NULL FULLTEXT INDEX WITH(analyzer = 'English', backend = 'bloom', case_sensitive = 'false', false_positive_rate = '0.01', granularity = '10240'), |
|
|
| | TIME INDEX ("ts") |
|
|
| | ) |
|
|
| | |
|
|
| | ENGINE=mito |
|
|
| | |
|
|
+-------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
|
|
|
DROP TABLE log_multi_fulltext_cols;
|
|
|
|
Affected Rows: 0
|
|
|
|
CREATE TABLE log_dup_fulltext_opts (
|
|
ts TIMESTAMP TIME INDEX,
|
|
msg TEXT FULLTEXT FULLTEXT,
|
|
);
|
|
|
|
Error: 1004(InvalidArguments), Invalid column option, column name: msg, error: expect INDEX after FULLTEXT keyword
|
|
|
|
CREATE TABLE log_with_invalid_type (
|
|
ts TIMESTAMP TIME INDEX,
|
|
msg INT FULLTEXT INDEX,
|
|
);
|
|
|
|
Error: 1004(InvalidArguments), Invalid column option, column name: msg, error: FULLTEXT index only supports string type
|
|
|
|
CREATE TABLE log_with_invalid_option (
|
|
ts TIMESTAMP TIME INDEX,
|
|
msg TEXT FULLTEXT INDEX WITH (analyzer='English', invalid_option='true'),
|
|
);
|
|
|
|
Error: 1004(InvalidArguments), Invalid column option, column name: msg, error: invalid FULLTEXT INDEX option: invalid_option
|
|
|