Blog · Tinybird

Adding JOIN support for parallel replicas on ClickHouse

We recently introduced a pull request to ClickHouse that enables simple JOIN support for parallel replicas on ClickHouse. The solution may be simple and naive, but the ceiling for performance on distributed queries just got WAY higher.

Javier Santana

Co-founder

Jun 8, 2023

Tinybird Blog

Useful stuff to help you become a better data developer.

Adding JOIN support for parallel replicas on ClickHouse

Latest news

Why we just released a huge upgrade to our VS Code Extension

5 Snowflake struggles that every Data Engineer deals with

Using custom Kafka headers for advanced message processing

Become a better data developer.

The 8 considerations for designing public data APIs

Upgrading short link analytics by 100x with Steven Tey

Building privacy-first native app telemetry with Guilherme Oenning

How to build a real-time fraud detection system

The 5 rules for writing faster SQL queries

Low-code analytics with James Devonport of UserLoop

Automating customer usage alerts with Tinybird and Make

7 strategies we're using to reduce cloud infrastructure costs in 2023

Real-time Databases: What developers need to know

Chatting GraphQL with Jamie Barton of Grafbase

Generate mock data schemas with GPT

A free and open source mock data generator for your next data project

Building real-time solutions with Snowflake at a fraction of the cost

The power of real-time streaming analytics with Confluent and Tinybird

Tinyshop: Get Tinybird swag delivered to your doorstep

Building a faster CI pipeline with Turborepo and pnpm

Developer Q&A: Monitoring global API latency with chronark

Developer Q&A with JR the Builder, co-creator of Beam Analytics

Data-Driven Talk: Build fast APIs, faster, over data at scale

Real-time analytics, a definitive guide

Build fast charts faster with the Tinybird Grafana plugin

Build serverless real-time analytics on Vercel with Tinybird

Simplifying event sourcing with scheduled data snapshots in Tinybird

Building an enterprise-grade real-time analytics platform

Transforming real-time applications with Tinybird and Google BigQuery

More Data, More Apps: Improving data ingestion in Tinybird

How we cut our CI pipeline execution time in half

Log Analytics: how to identify trends and correlations that Log Analysis tools cannot

Horizontally scaling Kafka consumers with rendezvous hashing

The top emojis on Twitter for every hour of 2022

Tinybird is SOC 2 Type II compliant

Three approaches to multi-tenant SaaS with Tinybird

Measuring World Cup sentiment with Twitter and Tinybird

Understanding the Data Warehouse

Multi-tenancy in Tinybird with a shared Workspace

Row-level security in Tinybird

Comparing Tinybird to AWS Kinesis, S3, Glue, and Athena

Introducing a redesigned Tinybird UI for better developer productivity

When you should use columnar databases and not Postgres, MySQL, or MongoDB

We launched an open source ClickHouse Knowledge Base

The Data Journey: Unlocking data for the right now

You can now explore and analyze time series data in Tinybird

Looking for an open source Google Analytics alternative? Set one up in 3 minutes.

How Session Rewind rapidly built an affordable session replay tool with Tinybird

How I replaced Google Analytics with Retool and Tinybird, Part 2

We've improved notifications for ingestion issues

How an eCommerce giant replaced Google Analytics for privacy and speed

How I replaced Google Analytics with Retool and Tinybird, Part 1

A privacy-first approach to building a Google Analytics alternative

What is a data product?

The best metaphor for real-time analytics

Text search at scale with ClickHouse

The data rules worth $40,000 a day

To the limits of SQL... and beyond

Big security updates from Tinybird

Use AWS SNS to send data to Tinybird

Usage-based pricing: Should you build or buy?

How we recreated r/place with 10 lines of SQL

DataMarket replaced 4 data stack tools with Tinybird

Changelog #21: Quickstart on loading events to Tinybird

Thinking in Tinybird

The hard parts of building data systems with high concurrency

I built a Tinybird syntax highlighter for VSCode

How to monitor Tinybird using Datadog with vector.dev

What are Materialized Views and why do they matter for real-time?

Roll up data with Materialized Views

You can now see how much data your endpoints scan in real-time

You can now create Materialized Views in the Tinybird UI

How Typeform Built a Fully Functional User Dash With Tinybird

Designing a faster data model to personalize browsing in real time

Looking ahead to Kafka Summit '22

Changelog #20: Data Source descriptions and beta testing of Parquet ingestion