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

 

[JingsongLee]

Hi,

user-zh我就说中文啦.
你需要设置成bigint.
具体报什么错？

Best,
Jingsong Lee


------------------------------------------------------------------
From:刘世民 <[hidden email]>
Send Time:2020年1月2日(星期四) 13:47
To:user-zh <[hidden email]>
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

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







在 2020-01-02 14:32:59，"JingsongLee" <[hidden email]> 写道：

>Hi,
>
>user-zh我就说中文啦.
>你需要设置成bigint.
>具体报什么错？
>
>Best,
>Jingsong Lee
>
>
>------------------------------------------------------------------
>From:刘世民 <[hidden email]>
>Send Time:2020年1月2日(星期四) 13:47
>To:user-zh <[hidden email]>
>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
>