3 ms·
Pay attention that VictoriaLogs doesn't need any configuration and table schema in this benchmark - it is enough to ingest JSON lines, where every line contains
by valyala 2y ago
Pay attention that VictoriaLogs doesn't need any configuration and table schema in this benchmark - it is enough to ingest JSON lines, where every line contains a single ad serving event [1].
Also it is interesting to compare the original SQL queries [2] to LogsQL queries [3]. LogsQL queries are shorter and they are easier to understand even if you aren't familiar with LogsQL. See how to convert SQL to LogsQL [4].
[1] https://github.com/ClickHouse/ClickBench/tree/main/victorialogs https://github.com/ClickHouse/ClickBench/tree/main/victorial...
[2] https://github.com/ClickHouse/ClickBench/blob/main/clickhouse/queries.sql https://github.com/ClickHouse/ClickBench/blob/main/clickhous...
[3] https://github.com/ClickHouse/ClickBench/blob/main/victorialogs/queries.logsql https://github.com/ClickHouse/ClickBench/blob/main/victorial...
[4] https://docs.victoriametrics.com/victorialogs/sql-to-logsql/ https://docs.victoriametrics.com/victorialogs/sql-to-logsql/