system.table_engines

System table containing descriptions of table engines supported by the server and the features they support.

Description

Contains description of table engines supported by server and their feature support information.

This table contains the following columns (the column type is shown in brackets):

• name (String) — The name of table engine.
• supports_settings (UInt8) — Flag that indicates if table engine supports SETTINGS clause.
• supports_skipping_indices (UInt8) — Flag that indicates if table engine supports skipping indices.
• supports_projections (UInt8) — Flag that indicated if table engine supports projections.
• supports_sort_order (UInt8) — Flag that indicates if table engine supports clauses PARTITION_BY, PRIMARY_KEY, ORDER_BY and SAMPLE_BY.
• supports_ttl (UInt8) — Flag that indicates if table engine supports TTL.
• supports_replication (UInt8) — Flag that indicates if table engine supports data replication.
• supports_deduplication (UInt8) — Flag that indicates if table engine supports data deduplication.
• supports_parallel_insert (UInt8) — Flag that indicates if table engine supports parallel insert (see max_insert_threads setting).
• description (String) — A description of what the table engine does. For engines that have a dedicated documentation page, this contains the full Markdown body of that page; for the remaining engines it is a concise summary.
• syntax (String) — How the table engine is used when creating a table. For most engines this is the ENGINE clause of a CREATE TABLE query, but some engines (such as the various kinds of views or the Loop engine) are used through other forms, such as CREATE VIEW or a SELECT from a table function.
• examples (String) — Usage examples.
• introduced_in (String) — The ClickHouse version in which the table engine was first introduced, in the form major.minor.
• related (Array(String)) — The names of related table engines.

Example

Query

SELECT
    name,
    supports_settings,
    supports_skipping_indices,
    supports_sort_order,
    supports_ttl,
    supports_replication,
    supports_deduplication,
    supports_parallel_insert
FROM system.table_engines
WHERE name IN ('Kafka', 'MergeTree', 'ReplicatedCollapsingMergeTree')

Response

┌─name──────────────────────────┬─supports_settings─┬─supports_skipping_indices─┬─supports_sort_order─┬─supports_ttl─┬─supports_replication─┬─supports_deduplication─┬─supports_parallel_insert─┐
│ MergeTree                     │                 1 │                         1 │                   1 │            1 │                    0 │                      0 │                        1 │
│ Kafka                         │                 1 │                         0 │                   0 │            0 │                    0 │                      0 │                        0 │
│ ReplicatedCollapsingMergeTree │                 1 │                         1 │                   1 │            1 │                    1 │                      1 │                        1 │
└───────────────────────────────┴───────────────────┴───────────────────────────┴─────────────────────┴──────────────┴──────────────────────┴────────────────────────┴──────────────────────────┘

See also

• MergeTree family query clauses
• Kafka settings
• Join settings