wang的专栏

--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_us.

-- 创建一个明细表 use test1; drop table if exists orders; create table orders ( uid UInt64, money UInt64, ctime Date, Sign Int8 ) engine = MergeTree() order by uid; insert into orders values(1, 100, toDate(now()), 1); insert into orders values(1.