chunjun icon indicating copy to clipboard operation
chunjun copied to clipboard

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

Open itsix opened this issue 1 year ago • 1 comments

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
			}
		}
	}
}

image

Code of Conduct

itsix avatar Apr 11 '23 07:04 itsix

像是写入Clickhouse的时候也是从里面去找dbo.t_chunjun的表,这样的话就是我writer部分的配置并未生效或者是在找表的时候自动加了dbo

itsix avatar Apr 11 '23 10:04 itsix