Clickhouse中buffer表设置及写入
Buffer Table Engine:https://clickhouse.com/docs/en/engines/table-engines/special/buffer
Buffer(database, table, num_layers, min_time, max_time, min_rows, max_rows, min_bytes, max_bytes [,flush_time [,flush_rows [,flush_bytes]]])
A Buffer table is used when too many INSERTs are received from a large number of servers over a unit of time, and data can’t be buffered before insertion, which means the INSERTs can’t run fast enough.
When the server is stopped, with DROP TABLE or DETACH TABLE, buffered data is also flushed to the destination table.
Core Settings:https://clickhouse.com/docs/en/operations/settings/settings#wait-for-async-insert