DTStack / DTStack/chunjun

[Question][sqlservercdc] 可以获取到变化的数据,但是报错`table $tableName not found.`

Open
#1,614 1 comment 0 reactions 0 assignees View on GitHub
question
Dominant language
Java
Stars
4.1k
Forks
1.7k
PR merge metrics
No merged PRs in 30d

Description

### Search before asking

- [X] I had searched in the [issues](https://github.com/DTStack/chunjun/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](https://dtstack.github.io/chunjun) but it didn't help me.

### Description

通过sqlservercdc可以实时检测到数据变化,但是在获取到变化的数据之后报错 `table $tableName not found`
json:
```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
}
}
}
}
```
![image](https://user-images.githubusercontent.com/103670004/231093999-4250c5a2-d0e9-43b3-a1fa-19d68cc44f0a.png)

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.