External Dictionaries

    ClickHouse:

    • Fully or partially stores dictionaries in RAM.
    • Allows to create external dictionaries with xml files or DDL queries.

    The configuration of external dictionaries can be located in one or more xml-files. The path to the configuration is specified in the parameter.

    The dictionary configuration file has the following format:

    You can configure any number of dictionaries in the same file.

    Attention

    You can convert values for a small dictionary by describing it in a query (see the function). This functionality is not related to external dictionaries.