ClickHouse DBA

Projections in ClickHouse

Projections in ClickHouse are commonly used to speed up the queries on the MergeTree table at the cost of storage....

Live Views in ClickHouse

Live Views in ClickHouse stores the result of the query used to create the view and it is different from...

Map Data Type in ClickHouse

Map data type in ClickHouse is used to store key-value pairs in table columns. A key-value pair consists of two...

Enhancing Performance and Scalability using Query Cache in ClickHouse

The query cache in any database significantly improves performance by reducing query execution time, decreasing server load, and optimizing resource...

ClickHouse Quotas – SQL reference

Quotas are used to track and limit the resource usage for users/roles in ClickHouse. We can set the quotas inside...