datax采集sqlserver数据报错
- 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