Skip to content

Which clickhouse engines dose chDB currently support and will support in the future #262

@DanielMao1

Description

@DanielMao1

Hello, I would like to know if there is a list to let me know that, amoung so many engines clickhouse provides, which are supported by chDB? As far as I know, Memory engine has some issues, so I would like to know, which are well supported? (To be more specific, MergeTree, AggregatingMergeTree, Memory are the three types we are now considering to use, I would like to know if they are supported)

Database engines:

Atomic
Lazy
Replicated
PostgreSQL
MySQL
SQLite
MaterializedPostgreSQL
MaterializedMySQL

Mergetree engines:

MergeTree
Data Replication
Custom Partitioning Key
ReplacingMergeTree
SummingMergeTree
AggregatingMergeTree
CollapsingMergeTree
VersionedCollapsingMergeTree
GraphiteMergeTree
Approximate Nearest Neighbor Search Indexes [experimental]
Full-text Indexes

Log engines:

Log
Stripelog
TinyLog

Integration engines:

Azure Blob Storage
DeltaLake
EmbeddedRocksDB
ExternalDistributed
TimeSeries
HDFS
Hive
Hudi
Iceberg
JDBC
Kafka
MaterializedPostgreSQL
MongoDB
MySQL
NATS
ODBC
PostgreSQL
RabbitMQ
Redis
S3
S3Queue
SQLite

special engines:

Distributed
Dictionary
Merge
Executable
File
Null
Set
Join
URL
View
Memory
Buffer
External Data
GenerateRandom
KeeperMap
FileLog

If you still prefer GitHub issues, remove all this text and ask your question here.

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionFurther information is requested

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions