commit 2e68c54: [Minor] Clickhouse: Change default partitioning schema

Vsevolod Stakhov vsevolod at highsecure.ru
Tue May 7 09:21:03 UTC 2019


Author: Vsevolod Stakhov
Date: 2019-05-07 10:17:20 +0100
URL: https://github.com/rspamd/rspamd/commit/2e68c548f43ebc987a8ee420499be480e71ace03 (HEAD -> master)

[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]],


More information about the Commits mailing list