美文网首页
【ClickHouse】How to create index

【ClickHouse】How to create index

作者: 光剑书架上的书 | 来源:发表于2022-02-14 13:20 被阅读0次

    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.

    参考:
    https://github.com/ClickHouse/ClickHouse/issues/31801

    相关文章

      网友评论

          本文标题:【ClickHouse】How to create index

          本文链接:https://www.haomeiwen.com/subject/kkfclrtx.html