Hi XiangWei,

Unfortunately, it's not possible for the Flink SQL API to join a stream with a common dataset now. As a workaround, if the table is just a tiny one, you can achieve a inner/left outer join with the user defined table functions. Note that due to some reasons, the UDTF left outer join cannot support arbitrary conditions now.

Hope that helps.



On 15/01/2018 6:11 PM, XiangWei Huang wrote:
Hi all,
   Is it possible to  join records read from a kafka stream with one(or more) dimension tables which are saved as mysql table using flink streaming sql.