[ https://issues.apache.org/jira/browse/FLINK-17657?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17112897#comment-17112897 ]
Leonard Xu commented on FLINK-17657: ------------------------------------ [~zhanglun] Thanks for the report, it's a bug from type mapping between mysql and flink sql type exists in JDBC connector. the root cause is that bigint unsigned range is {{0}} to {{18446744073709551615, }}{{bigint rang is }}{{-9223372036854775808}}{{ to }}{{9223372036854775807}}{{. so we cannot map a bigint unsigned to bigint(flink bigint has same range with mysql bigint)}}. [~JinxinTang] 's work around[1] is read String rather read the original BigInteger(jdbc treats bigint unsigned as java.math.BigInteger). [1][https://github.com/TJX2014/flink/blob/master-flink17657-jdbc-bigint/flink-examples/flink-examples-batch/src/main/java/org/apache/flink/examples/java/jdbc/JdbcReader.java#L49] > jdbc not support read BIGINT UNSIGNED field > ------------------------------------------- > > Key: FLINK-17657 > URL: https://issues.apache.org/jira/browse/FLINK-17657 > Project: Flink > Issue Type: Bug > Components: Connectors / JDBC, Table SQL / Client > Affects Versions: 1.10.0, 1.10.1 > Reporter: lun zhang > Priority: Major > Attachments: env.yaml, excetion.txt > > > I use sql client read mysql table, but I found I can't read a table contain > `BIGINT UNSIGNED` field. It will > Caused by: java.lang.ClassCastException: java.math.BigInteger cannot be cast > to java.lang.Long > > MySQL table: > > create table tb > ( > id BIGINT UNSIGNED auto_increment > primary key, > cooper BIGINT(19) null , > user_sex VARCHAR(2) null > ); > > my env yaml is env.yaml . -- This message was sent by Atlassian Jira (v8.3.4#803005)