[Test] More test cases for ClickHouse

1 files changed, 11 insertions, 0 deletions

diff --git a/test/functional/configs/clickhouse.conf b/test/functional/configs/clickhouse.conf
index 2e1b8d466..8f20b4dba 100644
--- a/test/functional/configs/clickhouse.conf
+++ b/test/functional/configs/clickhouse.conf
@@ -19,6 +19,17 @@ clickhouse {
   # IP:port of Clickhouse server
   server = "localhost:18123";
   allow_local = true;
+  retention {
+    # disabled by default
+    enable = true;
+    # drop | detach, please refer to ClickHouse docs for details
+    # http://clickhouse-docs.readthedocs.io/en/latest/query_language/queries.html#manipulations-with-partitions-and-parts
+    method = "drop";
+    # how many month the data should be kept in ClickHouse
+    period_months = 3;
+    # how often run the cleanup process
+    run_every = "7d";
+  }
 }
 logging = {
   type = "file",