alibaba / alibaba/DataX

datax采集sqlserver数据报错

Open
#2,128 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
17.4k
Forks
5.7k
PR merge metrics
No merged PRs in 30d

Description

在执行 datax采集sqlserver数据到doris 结果报错 [您配置错误. table和querySql 应该并且只能配置一个.]. - 您的配置有误. 因为table和querySql应该配置并且只能配置一个. 请检查您的配置并作出修改.

脚本:
{
"job": {
"setting": {
"speed": {
"channel": 1
}
},
"content": [
{
"reader": {
"name": "sqlserverreader",
"parameter": {
"username": "bigdataread",
"password": "*****",
"column": [
"[AutoCode]",
"[sDepCode]",
"[sDepName]",
"[sFDepCode]",
"[sGCode]",
"[sDepAbbName]",
"[sDepPerson]",
"[sDepPerson1]"
],
"connection": [
{
"jdbcUrl": "jdbc:sqlserver://locahost:****;DatabaseName=DatabaseName"
}
],
"table": [
"table_name"
]
}
},
"writer": {
"name": "doriswriter",
"parameter": {
"loadUrl": [
"ip:8030"
],
"loadProps": {
"format": "json",
"strip_outer_array": true
},
"column": [
"[AutoCode]",
"[sDepCode]",
"[sDepName]",
"[sFDepCode]",
"[sGCode]",
"[sDepAbbName]",
"[sDepPerson]",
"[sDepPerson1]"
],
"username": "hr_affairs",
"password": "*****",
"flushInterval": 30000,
"connection": [
{
"jdbcUrl": "jdbc:mysql://localhost:9030/hr_affairs",
"selectedDatabase": "hr_affairs",
"table": [
"ods__sqlserver__table_name__full"
]
}
]
}
}
}
]
}
}

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the supplied DataX job JSON and trace the sqlserverreader table/querySql validation that produces the reported message. No files or tests are named; done means determining whether the shown configuration triggers an incorrect validation error or needs a configuration correction.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.