table_engines
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 supportsSETTINGS
clause.supports_skipping_indices
(UInt8) β Flag that indicates if table engine supports skipping indices.supports_ttl
(UInt8) β Flag that indicates if table engine supports TTL.supports_sort_order
(UInt8) β Flag that indicates if table engine supports clausesPARTITION_BY
,PRIMARY_KEY
,ORDER_BY
andSAMPLE_BY
.supports_replication
(UInt8) β Flag that indicates if table engine supports data replication.supports_duduplication
(UInt8) β Flag that indicates if table engine supports data deduplication.supports_parallel_insert
(UInt8) β Flag that indicates if table engine supports parallel insert (seemax_insert_threads
setting).
Example:
SELECT *
FROM system.table_engines
WHERE name in ('Kafka', 'MergeTree', 'ReplicatedCollapsingMergeTree')
ββ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