commit 2143d4b: [Feature] Clickhouse: Utilise LowCardinality feature

Vsevolod Stakhov vsevolod at highsecure.ru
Tue May 21 18:28:03 UTC 2019


Author: Vsevolod Stakhov
Date: 2019-05-21 19:21:05 +0100
URL: https://github.com/rspamd/rspamd/commit/2143d4b1460fc275cef551e69b93d2a9e88327fa (HEAD -> master)

[Feature] Clickhouse: Utilise LowCardinality feature

---
 src/plugins/lua/clickhouse.lua | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/src/plugins/lua/clickhouse.lua b/src/plugins/lua/clickhouse.lua
index b4d5a859a..ccaee3042 100644
--- a/src/plugins/lua/clickhouse.lua
+++ b/src/plugins/lua/clickhouse.lua
@@ -105,7 +105,7 @@ CREATE TABLE rspamd
     IsSpf Enum8('reject' = 0, 'allow' = 1, 'neutral' = 2, 'dnsfail' = 3, 'na' = 4, 'unknown' = 5) DEFAULT 'unknown',
     NUrls Int32,
     Action Enum8('reject' = 0, 'rewrite subject' = 1, 'add header' = 2, 'greylist' = 3, 'no action' = 4, 'soft reject' = 5, 'custom' = 6) DEFAULT 'no action',
-    CustomAction String,
+    CustomAction LowCardinality(String),
     FromUser String,
     MimeUser String,
     RcptUser String,
@@ -122,9 +122,9 @@ CREATE TABLE rspamd
     `Urls.Url` Array(String),
     Emails Array(String),
     ASN String,
-    Country FixedString(2),
+    Country LowCardinality(FixedString(2)),
     IPNet String,
-    `Symbols.Names` Array(String),
+    `Symbols.Names` Array(LowCardinality(String)),
     `Symbols.Scores` Array(Float32),
     `Symbols.Options` Array(String),
     ScanTimeReal UInt32,


More information about the Commits mailing list