3 ms·

DuckDB's AsOf Joins: Fuzzy Temporal Lookups

• zX41ZdbW 3y ago
  Only a few database engines have support for ASOF JOIN. Originally implemented in ClickHouse in 2019: https://clickhouse.com/docs/en/sql-reference/statements/select/join#asof-join-usage https://clickhouse.com/docs/en/sql-reference/statements/sele... but now in a few more database engines.
  • nhourcard 3y ago
    QuestDB: https://questdb.io/docs/reference/sql/join/#asof-join https://questdb.io/docs/reference/sql/join/#asof-join
    • maxxen 3y ago
      Kdb(been around since the 90s) https://code.kx.com/q/ref/aj/ https://code.kx.com/q/ref/aj/
      • hodgesrm 3y ago
        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.