How to create index for Map Type Column or one key of it?
[version 21.8.10 revision 54449] #31801
You can create index for map keys, or for map values. Example:
CREATE TABLE test_table
(
id UInt64,
value Map(Int64, String),
index value_key_index mapKeys(value) TYPE bloom_filter GRANULARITY 4
) ENGINE=MergeTree ORDER BY id;
Link to documentation https://clickhouse.com/docs/en/engines/table-engines/mergetree-family/mergetree/#available-types-of-indices.
How to create index for Map Type Column or one key of it?...
# 0. clickhouse-index：https://clickhouse.yandex/ 1. click...
Index Create Index Grammar CREATE INDEX 不能用来创建PRIAMARY_KE...
create index 名称 on 表名;create index i经营异常版本 on 经营异常(版本);
1.语法 clickhouse创建用户语法： CREATE USER [IF NOT EXISTS | OR RE...
1. Index 1.1 Creating an Index CREATE INDEX ON:label (nod...
1.为普通字段添加索引，并且为索引命名 db.集合名.createIndex( {"字段名": 1 },{"nam...
In this tutorial, you learn how to create a graph and how...
How to Use Sketch to Create Mockups How to Use Sketch to ...
How to create scenarios for different RC corner? create_c...
本文标题：【ClickHouse】How to create index
本文链接：https://www.haomeiwen.com/subject/kkfclrtx.html
网友评论