News for hackers. Stuff that matters.

A comment on DuckDB's AsOf Joins: Fuzzy Temporal Lookups.

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 ]