ASOF JOIN Benchmark: Apache Doris vs ClickHouse and DuckDB

• From: Saqib Ali | Date: Wed, 24 Jun 2026 04:17:48 +0000 #
  Subject: ASOF JOIN Benchmark: Apache Doris vs ClickHouse and DuckDB

  https://www.velodb.io/blog/asof-join-benchmark-apache-doris-vs-clickhouse-and-duckdb A stock trade prints at 10.250. The quote that explains its price arrived at 10.980. An equality join will never pair those two rows, because the timestamps differ by 270 milliseconds. The query you need says: for each trade, find the latest quote at or before the trade time, for the same ticker. SQL engines call this ASOF JOIN, and most major analytical databases now ship it. Writing the same logic without it takes a correlated subquery or a window-function detour, and both get expensive at billions of rows. An engine with native support can run the key match and the time lookup as a single operator. Read More: https://www.velodb.io/blog/asof-join-benchmark-apache-doris-vs-clickhouse-and-duckdb

  [ Reply ]