From 2e68c548f43ebc987a8ee420499be480e71ace03 Mon Sep 17 00:00:00 2001 From: Vsevolod Stakhov Date: Tue, 7 May 2019 10:17:20 +0100 Subject: [PATCH] [Minor] Clickhouse: Change default partitioning schema --- src/plugins/lua/clickhouse.lua | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/plugins/lua/clickhouse.lua b/src/plugins/lua/clickhouse.lua index b9a3c2e09..928b6b283 100644 --- a/src/plugins/lua/clickhouse.lua +++ b/src/plugins/lua/clickhouse.lua @@ -135,7 +135,7 @@ CREATE TABLE rspamd MIMEFrom ALIAS if(MimeFrom = '', '', concat(MimeUser, '@', MimeFrom)), MIMERcpt ALIAS MimeRecipients[1] ) ENGINE = MergeTree() -PARTITION BY Date +PARTITION BY toMonday(Date) ORDER BY TS ]], [[CREATE TABLE rspamd_version ( Version UInt32) ENGINE = TinyLog]], -- 2.39.5