For your case, you should use a temporal table join syntax, and set up a refresh TTL for the RHS join cache.
Taras Moisiuk <t.v.mois...@gmail.com> 于2020年12月28日周一 下午7:21写道: > Hi Danny, > > I use regular join and it looks like: > > SELECT > ... > FROM *dynamic_kafka_table* k > JOIN *jdbc_table* j ON k.id = j.k_id > > > Should I set some additional conditions for this join? > > ------------------------------ > Sent from the Apache Flink User Mailing List archive. mailing list archive > <http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/> at > Nabble.com. >