jirislav opened a new issue, #39486: URL: https://github.com/apache/doris/issues/39486
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description When analyzing relational time-series data, it is essential to have the ability to join multiple datasets using time dimension by looking up at the value being closest in time. Without proper query engine support, users are forced to implement inefficient work-around which is both slow & hard to read. DuckDB has a great explanation [here](https://duckdb.org/docs/guides/sql_features/asof_join.html). Many other popular databases & query engines support it: - [ClickHouse ASOF join](https://clickhouse.com/docs/en/sql-reference/statements/select/join#asof-join-usage) - [QuestDB ASOF join](https://questdb.io/docs/reference/sql/join/#asof-join) - [Snowflake ASOF join](https://docs.snowflake.com/en/sql-reference/constructs/asof-join) - [Polars ASOF join](https://docs.pola.rs/py-polars/html/reference/dataframe/api/polars.DataFrame.join_asof.html) - [DolphinDB ASOF join](https://docs.dolphindb.com/en/Programming/SQLStatements/TableJoiners/asofjoin.html) - [Kdb ASOF join](https://code.kx.com/q/ref/aj/) - [Quasar ASOF join](https://blog.quasar.ai/timeseries-what-are-asof-joins) - [Kinetica ASOF join](https://docs.kinetica.com/7.1/sql/query/#sql-join-asof) - [Timeplus ASOF join](https://docs.timeplus.com/joins#append-asof-versioned) - [Shakti (k9) ASOF join](https://estradajke.github.io/k9-simples/k9/kSQL.html#asof) ### Use case _No response_ ### Related issues The most interesting is probably in DataFusion: - https://github.com/apache/datafusion/issues/318 ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
