Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Handling Large Volumes of Immutable Structured Data With ClickHouse

ACCU Conference via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

Taught by

ACCU Conference

Reviews

Start your review of Handling Large Volumes of Immutable Structured Data With ClickHouse

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.