chunjun
chunjun copied to clipboard
[Question][sqlservercdc] 可以获取到变化的数据,但是报错`table $tableName not found.`
Search before asking
-
[X] I had searched in the issues and found no similar question.
-
[X] I had googled my question but i didn't get any help.
-
[X] I had read the documentation: ChunJun doc but it didn't help me.
Description
通过sqlservercdc可以实时检测到数据变化,但是在获取到变化的数据之后报错 table $tableName not found
json:
{
"jobType": "sync",
"mode": "local",
"job": {
"content": [
{
"reader": {
"parameter": {
"databaseName": "af",
"tableList": [
"dbo.t_chunjun"
],
"username": "sa",
"password": "3637",
"cat": "insert,delete,update",
"url": "jdbc:sqlserver://xiaoliu1:1433;databaseName=af;encrypt=false",
"splitUpdate": true,
"pavingData": true,
"pollInterval": 1000
},
"name": "sqlservercdcreader"
},
"writer": {
"parameter": {
"column": [
"*"
],
"writeMode": "insert",
"encoding": "utf-8",
"connection": [
{
"jdbcUrl": "jdbc:clickhouse://xiaoliu3:8123/AFprouduct_V3_4",
"table": [
"t_chunjun"
]
}
],
"sourceIds": [
10
],
"password": "3637",
"username": "xiaoliu"
},
"name": "clickhousewriter"
}
}
],
"setting": {
"errorLimit": {
"record": 100
},
"speed": {
"bytes": 0,
"channel": 1
}
}
}
}
Code of Conduct
- [X] I agree to follow this project's Code of Conduct
像是写入Clickhouse的时候也是从里面去找dbo.t_chunjun的表,这样的话就是我writer部分的配置并未生效或者是在找表的时候自动加了dbo