- 博客(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 1197
原创 2021-04-22
clickhouse-ReplacingMergeTree demo目录clickhouse-ReplacingMergeTree demo1、建表语句CREATE TABLE replace_test( `ts` DateTime, `uid` String, `biz` String)ENGINE=ReplacingMergeTree(ts)PARTITION BY toYYYYMMDD(ts)primary key uidORDER BY uidSET...
2021-04-22 12:44:06 194
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人