jk-shah opened a new issue, #41309: URL: https://github.com/apache/beam/issues/41309
### What would you like to happen? Add native `ASOF JOIN` support to Beam SQL (`SqlTransform`) and a declarative `AsofJoin` transform to Python/Beam YAML. Unlike an interval join (which returns all matching right-hand rows within a window) or a standard equi-join, an `ASOF JOIN` matches each left event `(key, ts_left)` to the **single most recent** right-hand record `(key, ts_right)` where `ts_right <= ts_left` (with optional max-staleness tolerance and watermark-bounded state eviction). ### Motivation Many analytical SQL engines treat `ASOF JOIN` as a first-class primitive for real-time ML feature enrichment, financial tick/FX enrichment, and dynamic entity resolution without hand-writing `OrderedListStateSpec` + event-time timers. -- 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]
