<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[LHM112654的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/LHM112654</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; LHM112654]]></copyright><item><title><![CDATA[clickhouse ipv4 比较操作 踩坑]]></title><link>https://blog.youkuaiyun.com/LHM112654/article/details/116160650</link><guid>https://blog.youkuaiyun.com/LHM112654/article/details/116160650</guid><author>LHM112654</author><pubDate>Mon, 26 Apr 2021 16:29:40 +0800</pubDate><description><![CDATA[建表：

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,...]]></description><category></category></item><item><title><![CDATA[2021-04-22]]></title><link>https://blog.youkuaiyun.com/LHM112654/article/details/116002702</link><guid>https://blog.youkuaiyun.com/LHM112654/article/details/116002702</guid><author>LHM112654</author><pubDate>Thu, 22 Apr 2021 12:44:06 +0800</pubDate><description><![CDATA[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...]]></description><category></category></item></channel></rss>