Handling Large Volumes of Immutable Structured Data With ClickHouse

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Explore the power of ClickHouse for handling large volumes of immutable structured data in this ACCU 2021 conference talk. Learn about the open-source column-oriented database management system with SQL querying capabilities, written in C++. Discover how ClickHouse can be used to analyze massive datasets, such as 12 billion daily DNS transaction records, on a small cluster of servers. Gain insights into table definitions, table engines, materialized views, and data distribution across clusters. Follow along as the speaker demonstrates ClickHouse's capabilities using a large dataset on a laptop, showcasing its efficiency in online analytical processing. Understand the benefits of ClickHouse for developers working with high-volume, structured data and looking to perform SQL queries for analysis.

Syllabus

Introduction
ClickHouse Background
What is ClickHouse
Online Analytical Processing
Open Source
C
What I Like
Table Definition
Table Engine
Summing Merge Tree
Creating a materialized view
Distributing data across a cluster
rand
command line
aggregated data
query count
query on raw data