SQL层应用维表join jdbc的时候，请问怎么动态感知维表数据的变化呢？

[刘世民]

hi~
如图所示，在做kafka和jdbc 
join的时候，jdbc数据全量加载并为Finished状态，这种情况下请问怎么感知jdbc表的数据更新呢？还是我哪里的配置不对，还请赐教


小白敬上~

Re:Re: How should i set the field type in mysql when i use temporal table join between kafka and jdbc ?

[刘世民]

非常抱歉，是我这边的失误造成的结果，在schema中将字段类型设置成BIGINT就好啦，谢谢你！







在 2020-01-02 14:32:59，"JingsongLee"  写道：
>Hi,
>
>user-zh我就说中文啦.
>你需要设置成bigint.
>具体报什么错？
>
>Best,
>Jingsong Lee
>
>
>------
>From:刘世民 
>Send Time:2020年1月2日(星期四) 13:47
>To:user-zh 
>Subject:How should i set the field type in mysql when i use temporal table 
>join between kafka and jdbc ?
>
>
>for example, num_count field type is Long, but no matter if i set it to bigint 
>or something else in mysql table, it has always report errorr...
>so,what can i should set num_count field type in mysql? thanks
>
>Best !
>amenhub
>

How should i set the field type in mysql when i use temporal table join between kafka and jdbc ?

[刘世民]

for example, num_count field type is Long, but no matter if i set it to bigint 
or something else in mysql table, it has always report errorr...
so,what can i should set num_count field type in mysql? thanks


Best !
amenhub