查看数据集成新版任务,当前支持的任务类型包括:MySQL到Hologres整库实时解决方案。
调试
您可以在OpenAPI Explorer中直接运行该接口,免去您计算签名的困扰。运行成功后,OpenAPI Explorer可以自动生成SDK代码示例。
授权信息
当前API暂无授权信息透出。
请求参数
名称 | 类型 | 必填 | 描述 | 示例值 |
---|---|---|---|---|
DIJobId | long | 是 | 任务 ID。 | 11588 |
WithDetails | boolean | 否 | 是否返回详细配置信息,详细配置信息包括 TransformationRules、TableMappings、JobSettings。默认返回。 | true |
返回参数
示例
正常返回示例
JSON
格式
{
"Data": {
"ProjectId": 22,
"DIJobId": 11588,
"JobName": "mysql_to_holo_sync_445",
"Description": "mysql同步到hologres",
"MigrationType": "FullAndRealtimeIncremental",
"SourceDataSourceType": "MySQL",
"DestinationDataSourceType": "Hologres",
"SourceDataSourceSettings": [
{
"DataSourceName": "mysql_datasource_1",
"DataSourceProperties": {
"key": "TimeZone"
}
}
],
"DestinationDataSourceSettings": [
{
"DataSourceName": "holo_datasource_1",
"DataSourceProperties": {
"key": "TimeZone"
}
}
],
"ResourceSettings": {
"OfflineResourceSettings": {
"ResourceGroupIdentifier": "S_res_group_111_222"
},
"RealtimeResourceSettings": {
"ResourceGroupIdentifier": "S_res_group_111_222"
},
"RequestedCu": 0
},
"TransformationRules": [
{
"RuleActionType": "Rename",
"RuleExpression": "{\"expression\":\"${srcDatasoureName}_${srcDatabaseName}\"}",
"RuleName": "rename_rule_1",
"RuleTargetType": "Table"
}
],
"TableMappings": [
{
"SourceObjectSelectionRules": [
{
"Expression": "mysql_table_1",
"ObjectType": "Table"
}
],
"TransformationRules": [
{
"RuleActionType": "Rename",
"RuleName": "rename_rule_1",
"RuleTargetType": "Table"
}
]
}
],
"JobSettings": {
"ColumnDataTypeSettings": [
{
"SourceDataType": "bigint",
"DestinationDataType": "text"
}
],
"DdlHandlingSettings": [
{
"Action": "Critical",
"Type": "AddColumn"
}
],
"RuntimeSettings": [
{
"Name": "runtime.offline.concurrent",
"Value": "1"
}
],
"CycleScheduleSettings": {
"CycleMigrationType": "Full",
"ScheduleParameters": "bizdate=$bizdate"
},
"ChannelSettings": "{\"structInfo\":\"MANAGED\",\"storageType\":\"TEXTFILE\",\"writeMode\":\"APPEND\",\"partitionColumns\":[{\"columnName\":\"pt\",\"columnType\":\"STRING\",\"comment\":\"\"}],\"fieldDelimiter\":\"\"}\n"
},
"CreatedTime": 1671516776,
"CreatedUid": "100000001",
"UpdatedTime": 1673859985,
"UpdatedUid": "100000001",
"StartedTime": 1673859999,
"StartedUid": "100000001",
"JobStatus": "Finished",
"ErrorMessage": "error details xxx",
"RunStats": {
"key": "StructureMigrationTotalTables"
}
},
"RequestId": "0000-ABCD-EFG****"
}
错误码
HTTP status code | 错误码 | 错误信息 | 描述 |
---|---|---|---|
429 | Throttling.Api | The request for this resource has exceeded your available limit. | 对该资源的请求已超过您的可用上限。 |
429 | Throttling.System | The DataWorks system is busy. Try again later. | DataWorks系统繁忙,请稍后再试。 |
429 | Throttling.User | Your request is too frequent. Try again later. | 您的请求过于频繁,请尝试放缓请求速度。 |
500 | InternalError.System | An internal system error occurred. Try again later. | 系统内部错误,请稍后再试。 |
500 | InternalError.UserId.Missing | An internal system error occurred. Try again later. | 系统内部错误,请稍后再试。 |
访问错误中心查看更多错误码。
变更历史
变更时间 | 变更内容概要 | 操作 |
---|---|---|
2024-06-04 | OpenAPI 错误码发生变更、OpenAPI 返回结构发生变更 | 查看变更详情 |
2024-01-18 | OpenAPI 错误码发生变更、OpenAPI 返回结构发生变更 | 查看变更详情 |