[–] zX41ZdbW 2y 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/sele... but now in a few more database engines. [–] nhourcard 2y ago ↗ QuestDB: https://questdb.io/docs/reference/sql/join/#asof-join [–] maxxen 2y ago ↗ Kdb(been around since the 90s) https://code.kx.com/q/ref/aj/ [–] hodgesrm 2y 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.
[–] nhourcard 2y ago ↗ QuestDB: https://questdb.io/docs/reference/sql/join/#asof-join [–] maxxen 2y ago ↗ Kdb(been around since the 90s) https://code.kx.com/q/ref/aj/ [–] hodgesrm 2y 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.
[–] maxxen 2y ago ↗ Kdb(been around since the 90s) https://code.kx.com/q/ref/aj/ [–] hodgesrm 2y 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.
[–] hodgesrm 2y 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.
4 comments
[ 2.8 ms ] story [ 110 ms ] threadOriginally implemented in ClickHouse in 2019: https://clickhouse.com/docs/en/sql-reference/statements/sele... but now in a few more database engines.