In this article, i will take an PostgreSQL as a source database and give example. Here are a few ways you can increase the speed of migration from PostgreSQL to ClickHouse: Optimize the data for ClickHouse: ClickHouse is optimized for handling large amounts of data, but it is important to Continue Reading
ClickHouse
ClickHouse Indexes
ClickHouse is a high-performance open-source columnar database management system designed for online analytical processing. One of its key features is the use of indexes to speed up data retrieval and processing. In this article, we will cover the different types of indexes available in ClickHouse and provide examples of when Continue Reading
ClickHouse Database Engines
ClickHouse is a column-oriented database management system (DBMS) developed by Yandex for online analytical processing (OLAP) and high-performance data warehousing. It is known for its ability to handle large amounts of data and its high-performance query execution. ClickHouse supports several different database engines, each with its own strengths and use Continue Reading
Clone A Database In ClickHouse
Different methods can be made to clone a database. In some databases, this is quite easy to do. But no development has yet been made by ClickHouse to copy a database. As a solution to this issue, I developed a small tool. This tool takes a backup of the desired Continue Reading
ClickHouse Change Log Level
The Clickhouse server logs are often useful in diagnosing issues and understanding how clients are interacting with Clickhouse. They are however fairly low level and detailed out of the box. At this stage therefore, it is worth reducing the logging level to only show warnings and errors as opposed to Continue Reading
Read MongoDB Data From ClickHouse
In this article, you will learn how to read your data from ClickHouse which is stored in MongoDB. MongoDB engine is read-only table engine which allows to read data (SELECT queries) from remote MongoDB collection. Engine supports only non-nested data types. INSERT queries are not supported. First, you have to create a table Continue Reading