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