Replicated Database engine in ClickHouse

Photo Courtesy – Pexels ClickHouse has MergeTree family of engines and data replication can be achieved through the replicated version of the MergeTree family engines. This replication works on an individual table level. ClickHouse has recently […]

Streaming ClickHouse data to Kafka

Image Courtesy – Pexels ClickHouse has an inbuilt Kafka table engine which is commonly used to read streaming messages from Apache Kafka and store it in ClickHouse. This is one of the important and widely used […]

Conditional Functions

ClickHouse supports conditional functions, which are executed based on the specified condition. The syntax is given below.   Syntax:   if (condition, then_expression, else_expression)   If the condition evaluates to Null or Zero, the then_expression […]

Managing Roles in ClickHouse

The role is nothing but the position or purpose of an employee in an organization. ClickHouse supports role based access control to manage the users and entities accessing the database server. Every ClickHouse database user […]

User Defined Functions (UDF)

ClickHouse comes shipped with tons of useful functions that can make the lives easier for the users. ClickHouse also allows users to create and register their own custom functions, which are also known as user […]

Enumerated data type in ClickHouse

A ClickHouse table column of Enumerated data type can hold named values. We have to define the named values at the time of table creation. The main purpose is to efficiently store the columns with […]

Running ClickHouse in Docker – Part 2

Image Courtesy – Pexels ClickHouse is an open-source columnar database meant for online analytical processing workloads. We have covered how to set up ClickHouse using Docker in this post. In this article, we will cover […]

1 2 3