--buffer 表引擎 --创建一个目标表 create table tb_user_target(uid Int8, name String) engine=TinyLog; --创建一个缓存表 create table tb_user_buffer as tb_user_target engine = Buffer(test1, tb_user_target,16, 10, 100, 10000, 10000000, 10000000, 100000000); create table tb_user_buffer2 as tb_user_target engine = Buffer(test1, tb_user_target,16, 10, 100, 2, 10, 10000000, 100000000); insert into tb_user_buffer values(1, 'Yang'),(2, 'Haha'),(3,'ADA'); select * from tb_user_target; truncate table tb_user_target; insert into tb_user_buffer2 select number + 1, 'zss' from numbers(11); select * from tb_user_buffer2;
clickhouse buffer 引擎
最新推荐文章于 2023-12-21 17:20:15 发布