LowCardinality(T) | ClickHouse Docs
本文为摘录(或转载),侵删,原文为: https://clickhouse.com/docs/en/sql-reference/data-types/lowcardinality
1 LowCardinality(T)
https://clickhouse.com/docs/en/sql-reference/data-types/lowcardinality
Changes the internal representation of other data types to be dictionary-encoded.
1.1 Syntax
| |
Parameters:
data_typeString,FixedString,Date,DateTime, andnumbersexceptingDecimal.- LowCardinality is not efficient for some data types, see the
allow_suspicious_low_cardinality_typessetting description.
1.2 Description
LowCardinality is a superstructure that changes a data storage method and rules of data processing. ClickHouse applies dictionary coding to LowCardinality-columns. Operating with dictionary encoded data significantly increases performance of SELECT queries for many applications.