tis
tis copied to clipboard
MySQL->Mongo 数据同步 tinyint(1) 类型映射问题
MySQL表 ddlï¼
CREATE TABLE `orderdetail_01` (
`order_id` varchar(32) ,
`is_limittime` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1
{
"job":{
"content":[
{
"reader":{
"parameter":{
"password":"xxxxxx",
"column":[
"`order_id`",
"`is_limittime`"
],
"connection":[
{
"jdbcUrl":[
"jdbc:mysql://192.168.28.200:3306/order2?useUnicode=yes&useCursorFetch=true&useSSL=false&serverTimezone=Asia%2FShanghai&useCompression=true&characterEncoding=utf8"
],
"table":[
"`orderdetail_01`",
"`orderdetail_02`"
]
}
],
"dataxName":"mysql_mongo",
"username":"root"
},
"name":"mysqlreader"
},
"writer":{
"parameter":{
"userPassword":"xxxxxx",
"address":[
"192.168.28.201:27017"
],
"dbName":"tis",
"column":[
{
"name":"order_id",
"type":"string"
},
{
"name":"is_limittime",
"type":"boolean" // æ¤å¤æ å°æbooleanç±»å
}
],
"writeMode":{
"isReplace":true,
"replaceKey":"order_id"
},
"userName":"admin",
"collectionName":"orderdetail",
"dataxName":"mysql_mongo"
},
"name":"mongodbwriter"
},
"dataxName":"mysql_mongo"
}
],
"setting":{
"errorLimit":{
"record":1,
"percentage":0.02
},
"speed":{
"channel":3
}
}
}
}
卿§è¡è¿ç¨ä¸éè¿DataX读åçå 容为ï¼
{
"byteSize": 1,
"index": 42,
"rawData": 0,
"type": "LONG" // ä»MySQL读åçå
容åæLong
}
é乿¥åçéè¯¯ä¸ºï¼ "message": "record's [42] column's type should be: boolean"