What is the Best Recommended Table engine for clickhouse

[sunil sunny]

Hi team,

We have recently started working with clickhouse.

We are creating different tables in Click house.  

What is the default table engine for this. What is the best recommended by your team.

We are currently working on Single Server and we might expand to Multi server

We have seen two tools.  

Tiny log and Mergetree

What are the pros and cons for these two tools. which is best to use?

Can anyone help me on this please?

Thanks,

Sunil.

[Denis Zhuravlev]

Mergetree for real data.

I use Tinylog as temporary tables only for short living data (as a buffer during load into real table -- Mergetree).

https://clickhouse.yandex/docs/en/operations/table_engines/tinylog/

• If you are simultaneously reading from a table and writing to it in a different query, the read operation will complete with an error.
• If you are writing to a table in multiple queries simultaneously, the data will be broken

The typical way to use this table is write-once: first just write the data one time, then read it as many times as needed. Queries are executed in a single stream.

.....