WingNews logo WingNews
top | new | best | ask | show | jobs | submit
GitHub [2]
top | item 37523732

DuckDB's AsOf Joins: Fuzzy Temporal Lookups

14 points| szarnyasg | 2 years ago |duckdb.org

4 comments

order
[+] [-] zX41ZdbW|2 years ago|reply
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.

[+] [-] nhourcard|2 years ago|reply
QuestDB: https://questdb.io/docs/reference/sql/join/#asof-join
powered by hn/api // news.ycombinator.com