Z-Order sorting

Bilibili Tech

Jul 15, 2022 · Big Data

Lakehouse Architecture Practice at Bilibili: Query Acceleration and Index Enhancement

Bilibili’s lakehouse architecture merges Iceberg‑based data lake flexibility with data‑warehouse efficiency, using Kafka‑Flink real‑time ingestion, Spark offline loads, Trino queries, Alluxio caching, Z‑Order/Hilbert sorting, and enhanced BloomFilter and bitmap indexes to boost query speed up to tenfold while drastically cutting file reads.

Query OptimizationZ-Order sortingbig data architecture

0 likes · 17 min read

Lakehouse Architecture Practice at Bilibili: Query Acceleration and Index Enhancement

Bilibili Tech

Feb 17, 2022 · Big Data

Bilibili's Lakehouse Architecture: Building a Unified Data Lake and Data Warehouse

Bilibili replaced its Hive‑Spark‑Presto ETL pipeline with a lakehouse built on Iceberg, using Magnus, Trino and Alluxio to unify a PB‑scale data lake and warehouse, adding Z‑Order sorting and indexing for fast multi‑dimensional queries while planning further schema and pre‑computation optimizations.

IndexingQuery OptimizationZ-Order sorting

0 likes · 14 min read

Bilibili's Lakehouse Architecture: Building a Unified Data Lake and Data Warehouse