Hi Jaqie, If I understand your question correctly, it seems you are finding a solution about the Stream table and Dim table(you called static table) join.
There were many users who asked this question. Linked some reply here[1][2] to let you consider. Best, Vino [1]: http://apache-flink-mailing-list-archive.1008284.n3.nabble.com/How-to-Join-a-dimension-table-in-flink-sql-td20729.html [2]: http://www.codeha.us/apache-flink-users/msg12421.html Jaqie Chan <jaqi...@gmail.com> 于2019年11月9日周六 下午3:04写道: > Hello, > > I have questions about static table in flink. > > Join the stream table with static table. I'm looking at temporal table, > while the time based table would grow exponentially over period. Any > suggestions? > > Stream tables checks the contains in static table(updates once everyday > with new set of data). Trying to approach this with views. > > Thanks for any suggestions. > > Regards > 嘉琪 > >