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.

    系统。字典

    包含以下信息 .

    • (字符串) — Name of the database containing the dictionary created by DDL query. Empty string for other dictionaries.
    • name () — 字典名称.
    • status () — Dictionary status. Possible values:
      • NOT_LOADED — Dictionary was not loaded because it was not used.
      • LOADED — Dictionary loaded successfully.
      • FAILED — Unable to load the dictionary as a result of an error.
      • LOADING — Dictionary is loading now.
      • LOADED_AND_RELOADING — Dictionary is loaded successfully, and is being reloaded right now (frequent reasons: SYSTEM RELOAD DICTIONARY 查询，超时，字典配置已更改）。
    • () — Path to the configuration file that describes the dictionary.
    • type (字符串) — Type of a dictionary allocation. .
    • key — 密钥类型:数字键 () or Сomposite key (字符串) — form “(type 1, type 2, …, type n)”.
    • attribute.names ((字符串)) — Array of 由字典提供。
    • attribute.types (阵列()) — Corresponding array of 属性类型 这是由字典提供。
    • bytes_allocated () — Amount of RAM allocated for the dictionary.
    • query_count (UInt64) — Number of queries since the dictionary was loaded or since the last successful reboot.
    • hit_rate () — For cache dictionaries, the percentage of uses for which the value was in the cache.
    • (Float64) — Percentage filled in the dictionary (for a hashed dictionary, the percentage filled in the hash table).
    • source () — Text describing the 数据源 为了字典
    • lifetime_min () — Minimum 使用寿命 在内存中的字典，之后ClickHouse尝试重新加载字典（如果 invalidate_query 被设置，那么只有当它已经改变）。 在几秒钟内设置。
    • lifetime_max () — Maximum 使用寿命 在内存中的字典，之后ClickHouse尝试重新加载字典（如果 invalidate_query 被设置，那么只有当它已经改变）。 在几秒钟内设置。
    • loading_start_time () — Start time for loading the dictionary.
    • last_successful_update_time (日期时间) — End time for loading or updating the dictionary. Helps to monitor some troubles with external sources and investigate causes.
    • loading_duration () — Duration of a dictionary loading.
    • (字符串) — Text of the error that occurs when creating or reloading the dictionary if the dictionary couldn’t be created.

    示例

    确保字典已加载。