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

系统。表_engines

包含服务器支持的表引擎的描述及其功能支持信息。

此表包含以下列（列类型显示在括号中):

  • name (String) — The name of table engine.
  • supports_settings (UInt8) — Flag that indicates if table engine supports SETTINGS 条款
  • supports_skipping_indices (UInt8) — Flag that indicates if table engine supports 跳过索引.
  • supports_ttl (UInt8) — Flag that indicates if table engine supports TTL.
  • supports_sort_order (UInt8) — Flag that indicates if table engine supports clauses PARTITION_BY, PRIMARY_KEY, ORDER_BY 和 SAMPLE_BY.
  • supports_replication (UInt8) — Flag that indicates if table engine supports 数据复制.
  • supports_duduplication (UInt8) — Flag that indicates if table engine supports data deduplication.

示例:

  1. SELECT *
  2. FROM system.table_engines
  3. WHERE name in ('Kafka', 'MergeTree', 'ReplicatedCollapsingMergeTree')
  1. ┌─name──────────────────────────┬─supports_settings─┬─supports_skipping_indices─┬─supports_sort_order─┬─supports_ttl─┬─supports_replication─┬─supports_deduplication─┐
  2. │ Kafka                         │                 1 │                         0 │                   0 │            0 │                    0 │                      0 │
  3. │ MergeTree                     │                 1 │                         1 │                   1 │            1 │                    0 │                      0 │
  4. │ ReplicatedCollapsingMergeTree │                 1 │                         1 │                   1 │            1 │                    1 │                      1 │
  5. └───────────────────────────────┴───────────────────┴───────────────────────────┴─────────────────────┴──────────────┴──────────────────────┴────────────────────────┘

另请参阅