ChistaDATA

Drop & UnDrop Table In ClickHouse

Starting from ClickHouse version 23.3, It is now feasible to recover a dropped table in an Atomic database, provided that...

Creating an Admin User in ClickHouse

ClickHouse creates a user named ‘default’, at the time of installation/fresh deployment. This default user has unrestricted access to the...

Live Views in ClickHouse

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

WHERE vs PREWHERE in ClickHouse

PREWHERE is an optimization applied automatically even if you write WHERE in the query. A separate keyword lets you manually...

Setting Up a Replicated ClickHouse Cluster with ClickHouse Keeper

Introduction In this knowledge base article, we will guide you through setting up a replicated ClickHouse cluster with the invaluable...