mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-05-14 20:10:37 +00:00
73c267e641
* fix(mito): ignore compaction override in enum option validation Signed-off-by: QuakeWang <wangfuzheng0814@foxmail.com> * test: cover compaction override without compaction type Signed-off-by: QuakeWang <wangfuzheng0814@foxmail.com> * fix(mito): short-circuit enum option validation Signed-off-by: QuakeWang <wangfuzheng0814@foxmail.com> --------- Signed-off-by: QuakeWang <wangfuzheng0814@foxmail.com>
91 lines
1.9 KiB
SQL
91 lines
1.9 KiB
SQL
CREATE TABLE not_supported_table_options_keys (
|
|
`id` INT UNSIGNED,
|
|
host STRING,
|
|
cpu DOUBLE,
|
|
disk FLOAT,
|
|
ts TIMESTAMP NOT NULL DEFAULT current_timestamp(),
|
|
TIME INDEX (ts),
|
|
PRIMARY KEY (id, host)
|
|
)
|
|
PARTITION ON COLUMNS (`id`) (
|
|
`id` < 5,
|
|
`id` >= 5 AND `id` < 9,
|
|
`id` >= 9
|
|
)
|
|
ENGINE=mito
|
|
WITH(
|
|
foo = 123,
|
|
ttl = '7d',
|
|
write_buffer_size = 1024
|
|
);
|
|
|
|
create table if not exists test_opts(
|
|
host string,
|
|
ts timestamp,
|
|
cpu double default 0,
|
|
memory double,
|
|
TIME INDEX (ts),
|
|
PRIMARY KEY(host)
|
|
)
|
|
engine=mito
|
|
with(ttl='7d', 'compaction.type'='twcs', 'compaction.twcs.time_window'='1d');
|
|
|
|
drop table test_opts;
|
|
|
|
create table if not exists test_opts(
|
|
host string,
|
|
ts timestamp,
|
|
cpu double default 0,
|
|
memory double,
|
|
TIME INDEX (ts),
|
|
PRIMARY KEY(host)
|
|
)
|
|
engine=mito
|
|
with('ttl'='7d', 'compaction.type'='twcs', 'compaction.twcs.time_window'='1d');
|
|
|
|
drop table test_opts;
|
|
|
|
create table if not exists test_mito_options(
|
|
host string,
|
|
ts timestamp,
|
|
cpu double default 0,
|
|
memory double,
|
|
TIME INDEX (ts),
|
|
PRIMARY KEY(host)
|
|
)
|
|
engine=mito
|
|
with(
|
|
'ttl'='7d',
|
|
'compaction.type'='twcs',
|
|
'compaction.twcs.trigger_file_num'='2',
|
|
'compaction.twcs.time_window'='1d',
|
|
'index.inverted_index.ignore_column_ids'='1,2,3',
|
|
'index.inverted_index.segment_row_count'='512',
|
|
'wal_options'='{"wal.provider":"raft_engine"}',
|
|
'memtable.type' = 'partition_tree',
|
|
);
|
|
|
|
drop table test_mito_options;
|
|
|
|
create table if not exists test_compaction_override_without_type(
|
|
host string,
|
|
ts timestamp,
|
|
memory double,
|
|
TIME INDEX (ts),
|
|
PRIMARY KEY(host)
|
|
)
|
|
engine=mito
|
|
with('compaction.override'='true');
|
|
|
|
drop table test_compaction_override_without_type;
|
|
|
|
create table if not exists invalid_compaction(
|
|
host string,
|
|
ts timestamp,
|
|
memory double,
|
|
TIME INDEX (ts),
|
|
PRIMARY KEY(host)
|
|
)
|
|
engine=mito
|
|
with('compaction.type'='twcs', 'compaction.twcs.trigger_file_num'='8d');
|