Breeze0806 / go-etl

go-etl is a toolset for data extraction, transformation and loading。(go-etl是一个集数据源抽取,转化,加载的工具集,提供强大的数据同步能力)
Apache License 2.0
118 stars 38 forks source link

I got a error: filed:t_unsigned_bigint type(UNSIGNED BIGINT) is not supportted #31

Closed hellousworld closed 6 months ago

hellousworld commented 6 months ago

Hello friend, My software version:
win10 go-etl v0.1.7 reader: MySQL5.7.26 (use init.sql init the database) writer: MySQL5.7.26 (use init.sql init the database)

After run datax -c config.json I got a error: filed:t_unsigned_bigint type(UNSIGNED BIGINT) is not supportted,
How to fix it, thanks.

config.json { "core" : { "container": { "job":{ "id": 1, "sleepInterval":100 } } }, "job":{ "content":[ { "reader":{ "name": "mysqlreader", "parameter": { "username": "root", "password": "123456", "column": [""], "connection": { "url": "tcp(127.0.0.1:3306)/source?parseTime=false", "table": { "db":"source", "name":"type_table" } }, "where": "" } }, "writer":{ "name": "mysqlwriter", "parameter": { "username": "root", "password": "123456", "writeMode": "insert", "column": [""], "session": [], "preSql": [], "connection": { "url": "tcp(127.0.0.1:3306)/mysql?parseTime=false", "table": { "db":"destination", "name":"type_table" } }, "batchTimeout": "1s", "batchSize":1000 } }, "transformer":[] } ] } }

Breeze0806 commented 6 months ago

Thanks for your feedback. I will try to reproduce it soon.

Breeze0806 commented 6 months ago

@hellousworld . Thank you for submitting the issue that is very helpful to me. This issue is caused by the lack of unsigned type judgment in storage/database/mysql/field.go(6e7eaa8da5f8172131d9a2af480bcfc53ee08151) . You now can download the v0.1.8 version to solve it

hellousworld commented 6 months ago

thanks a lot. I try it.