Mihai Budiu created CALCITE-6372:
------------------------------------
Summary: Support ASOF joins
Key: CALCITE-6372
URL: https://issues.apache.org/jira/browse/CALCITE-6372
Project: Calcite
Issue Type: New Feature
Components: core
Affects Versions: 1.36.0
Reporter: Mihai Budiu
Seems that this new kind of JOIN named AS OF is very useful for processing
time-series data. Here is some example documentation from Snowflake:
https://docs.snowflake.com/en/sql-reference/constructs/asof-join
The semantics is similar to a traditional join, but the result always contains
at most one record from the left side, with the last​ matching record on the
right side (where "time" is any value that can be compared for inequality).
This can be expressed in SQL, but it looks very cumbersome, using a JOIN, a
GROUP BY, and then an aggregation to keep the last value.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
