- 博客(2)
- 资源 (2)
- 收藏
- 关注
原创 clickhouse ipv4 比较操作 踩坑
建表: create table test.detail_ehire_local( time Int64, date Date, ip IPv4 )ENGINE = ReplacingMergeTree() PARTITION BY toYYYYMMDD(date) ORDER BY (date) PRIMARY KEY (date) SETTINGS index_granularity = 8192; 插入数据后执行查询操作 Select time,...
2021-04-26 16:29:40
1364
原创 2021-04-22
clickhouse-ReplacingMergeTree demo 目录 clickhouse-ReplacingMergeTree demo 1、建表语句 CREATE TABLE replace_test( `ts` DateTime, `uid` String, `biz` String )ENGINE=ReplacingMergeTree(ts) PARTITION BY toYYYYMMDD(ts) primary key uid ORDER BY uid SET...
2021-04-22 12:44:06
247
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人
RSS订阅