Flink SQL Streaming Concept -- Join in Continuous Queries

Joins in Continuous Queries

Regular Joins

select *
  from Orders
inner join Product on Orders.product_id = Product.id

允许在 input tables 进行 updating(insert update delete)

缺点：一直保存join两端的表状态

Interval Joins

select *
  from Orders o
     , Shipments s
 where o.id = s.order_id
   and o.order_time between s.ship_time - interval '4' HOUR and s.ship_time

只支持append的时间属性表。因为时间属性的单调递增，Flink能删除不影响正确结果的老的状态值

Join with a temporal Table Function

Append-only table left join with a temporal table