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.
Best,
Xingcan
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.