diff options
Diffstat (limited to '')
-rwxr-xr-x | tests/clickhouse-bulk-load.sh | 30 |
1 files changed, 30 insertions, 0 deletions
diff --git a/tests/clickhouse-bulk-load.sh b/tests/clickhouse-bulk-load.sh new file mode 100755 index 0000000..3f4099e --- /dev/null +++ b/tests/clickhouse-bulk-load.sh @@ -0,0 +1,30 @@ +#!/bin/bash +# add 2018-12-07 by Pascal Withopf, released under ASL 2.0 +. ${srcdir:=.}/diag.sh init +export NUMMESSAGES=100000 + +generate_conf +add_conf ' +module(load="../plugins/omclickhouse/.libs/omclickhouse") + +template(name="outfmt" option.stdsql="on" type="string" string="INSERT INTO rsyslog.bulkLoad (id, ipaddress, message) VALUES (%msg:F,58:2%, ' +add_conf "'%fromhost-ip%', '%msg:F,58:2%')" +add_conf '") + + +:syslogtag, contains, "tag" action(type="omclickhouse" server="localhost" port="8443" + user="default" pwd="" template="outfmt") +' + +clickhouse-client --query="CREATE TABLE IF NOT EXISTS rsyslog.bulkLoad ( id Int32, ipaddress String, message String ) ENGINE = MergeTree() PARTITION BY ipaddress Order By id" + +startup +injectmsg +shutdown_when_empty +wait_shutdown +clickhouse-client --query="SELECT message FROM rsyslog.bulkLoad ORDER BY id" > $RSYSLOG_OUT_LOG + +clickhouse-client --query="DROP TABLE rsyslog.bulkLoad" +seq_check 0 $(( NUMMESSAGES - 1 )) + +exit_test |