You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Mihai Budiu (Jira)" <ji...@apache.org> on 2024/04/16 17:34:00 UTC

[jira] [Created] (CALCITE-6372) Support ASOF joins

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)