ClickHouse DBA

ClickHouse User Defined Functions (UDFs) from an external script

ClickHouse supports user-defined functions (UDF) that can either be created based on the built-in functions in ClickHouse or from an...

Geo Data Types in ClickHouse

ClickHouse has an in-built data type to store geographical objects. The following data types to store and work with geographical...

How to add new replica node in ClickHouse Cluster setup with ClickHouse Keeper

In a ClickHouse replication cluster, adding a new node is a common operation to scale your cluster and improve fault...

Truncate Table Error/Warning In ClickHouse

Error/Warning If table size bigger than your max_table_size_to_drop parameter’s value, you will get an error like this: “Code: 359. DB::Exception:...

gpg: failed to create temporary file Error During ClickHouse Installation

On Linux or Linux-like systems such as MacOS, you might get following error during ClickHouse Installation. Following command allows you...