Help wanted!

The following content of this documentation page has been machine-translated. But unlike other websites, it is not done on the fly. This translated text lives on GitHub repository alongside main ClickHouse codebase and waits for fellow native speakers to make it more human-readable. You can also use the original English version as a reference.

Help ClickHouse documentation by editing this page

字典

字典是一个映射 (key -> attributes）这是方便各种类型的参考清单。

ClickHouse支持使用可用于查询的字典的特殊功能。 这是更容易和更有效地使用字典与功能比 JOIN 与参考表。

NULL 值不能存储在字典中。

ClickHouse支持:

• 内置字典 具有特定的 功能集.
• 插件（外部）字典 用一个 功能集.

原始文章