clickhouse
clickhouse
newbieja
java
展开
-
clickhouse buffer 引擎
--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.原创 2022-01-24 12:19:55 · 620 阅读 · 0 评论 -
【无标题】clickhouse 物化视图 materialized view
-- 创建一个明细表 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.原创 2022-01-24 10:15:58 · 155 阅读 · 0 评论