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].
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/victorial...
[2] https://github.com/ClickHouse/ClickBench/blob/main/clickhous...
[3] https://github.com/ClickHouse/ClickBench/blob/main/victorial...
[4] https://docs.victoriametrics.com/victorialogs/sql-to-logsql/