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...

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...

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...