DuckDB's AsOf Joins: Fuzzy Temporal Lookups

Posted by szarnyasg on Friday September 15, 2023 @10:39AM
from the duckdb.org dept.

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

( 4 comments | 5 points | on HN )

Re:DuckDB's AsOf Joins: Fuzzy Temporal Lookups by zX41ZdbW on Friday September 15, 2023 @12:06PM (#37525186)

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.

[ Parent | on HN ]

Re:DuckDB's AsOf Joins: Fuzzy Temporal Lookups by nhourcard on Friday September 15, 2023 @01:04PM (#37526112)

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

[ Parent | on HN ]

Re:DuckDB's AsOf Joins: Fuzzy Temporal Lookups by maxxen on Friday September 15, 2023 @02:23PM (#37527186)

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

[ Parent | on HN ]

Re:DuckDB's AsOf Joins: Fuzzy Temporal Lookups by hodgesrm on Saturday September 16, 2023 @10:51AM (#37535279)

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.

[ Parent | on HN ]