Set up Clickhouse database for Kafka Streaming | Data Steraming | OLAP database | Clickhouse
In this video we will cover a columnar database called clickhouse. We will use Clickhouse as the target database for our Apache Kafka streaming. This will be a perfect match for our stream processing application and real-time data anlaysis. A columnar database is optimized for fast retrieval of columns of data, typically for an analytical application.
ClickHouse® is a high-performance, column-oriented SQL database for online analytical processing (OLAP). It has open source and a cloud base offering. You can use Clickhouse if you need real-time response over a large dataset.
Link to Clickhouse docs: #why-is-clickhouse-so-fast
Like to GitHub repo:
💥Subscribe to our channel:
📌 Links
-----------------------------------------
#️⃣ Follow me on social media! #️⃣
🔗 GitHub:
📸 Instagram:
📝 LinkedIn:
🔗 @hnawaz100
-----------------------------------------
#clickhouse #kafka #etl
Topics covered in this video:
==================================
0:00 - Introduction to Clickhouse
0:27 - Row vs Columnar database
2:14 - Clickhouse Set up
2:23 - Docker-compose overview
2:32 - Clickhouse configs
4:05 - Create and Start Cotainers
4:16 - Database connection
5:14 - JDBC Sink Connector
6:33 - Query Clickhouse to view Data Stream
1 view
118
18
6 months ago 01:19:54 1
Climate: The Movie (The Cold Truth) Updated 4K version
6 months ago 01:46:46 1
Boris Brejcha at Arènes de Nîmes, in France for Cercle
6 months ago 00:04:10 1
Sufjan Stevens - Visions of Gideon (From “Call Me By Your Name“ Soundtrack)
6 months ago 00:04:11 1
Slaughter to Prevail - BABA YAGA DrumCam from Oberhausen 18/01/24
6 months ago 00:07:05 1
“The Song Burning in the Embers“ Full Animated Short | Genshin Impact #GenshinImpact
6 months ago 00:20:00 21
American Truck Simulator: Nebraska - Gameplay Preview
6 months ago 00:04:01 1
VALHALLA CALLING by Miracle Of Sound ft. Peyton Parrish - OFFICIAL VIDEO