Have you encountered ClickHouse?

Yes, I have worked with ClickHouse in projects that required fast analytics of large data volumes. ClickHouse is a columnar DBMS optimized for OLAP queries. In Python, libraries such as clickhouse-driver or clickhouse-connect are often used to work with ClickHouse.

Example of a simple query using clickhouse-driver:

from clickhouse_driver import Client

client = Client('localhost')

result = client.execute('SELECT count() FROM my_table')
print(result)

ClickHouse is well-suited for collecting and analyzing logs, metrics, and other data where speed of aggregations is important.