DuckDB's AsOf Joins: Fuzzy Temporal Lookups(duckdb.org)

14 pointsby szarnyasg3 lata temu4 comments

DuckDB's AsOf Joins: Fuzzy Temporal Lookups

https://duckdb.org/2023/09/15/asof-joins-fuzzy-temporal-lookups.html

1 comments

Only a few database engines have support for ASOF JOIN.

Originally implemented in ClickHouse in 2019: https://clickhouse.com/docs/en/sql-reference/statements/sele... but now in a few more database engines.

nhourcard3 lata temu

QuestDB: https://questdb.io/docs/reference/sql/join/#asof-join

maxxen3 lata temu

Kdb(been around since the 90s) https://code.kx.com/q/ref/aj/

hodgesrm3 lata temu

Correct. As I recall ClickHouse ASOF joins drew direct inspiration from this feature in Kdb+ and were in fact implemented by an engineer with a background in financial apps.