查询实时数据同步服务。
调试
您可以在OpenAPI Explorer中直接运行该接口,免去您计算签名的困扰。运行成功后,OpenAPI Explorer可以自动生成SDK代码示例。
授权信息
下表是API对应的授权信息,可以在RAM权限策略语句的Action
元素中使用,用来给RAM用户或RAM角色授予调用此API的权限。具体说明如下:
- 操作:是指具体的权限点。
- 访问级别:是指每个操作的访问级别,取值为写入(Write)、读取(Read)或列出(List)。
- 资源类型:是指操作中支持授权的资源类型。具体说明如下:
- 对于必选的资源类型,用背景高亮的方式表示。
- 对于不支持资源级授权的操作,用
全部资源
表示。
- 条件关键字:是指云产品自身定义的条件关键字。
- 关联操作:是指成功执行操作所需要的其他权限。操作者必须同时具备关联操作的权限,操作才能成功。
操作 | 访问级别 | 资源类型 | 条件关键字 | 关联操作 |
---|---|---|---|---|
gpdb:DescribeStreamingJob | delete | *DBInstance acs:gpdb::{#accountId}:dbinstance/{#DBInstanceId} |
| 无 |
请求参数
名称 | 类型 | 必填 | 描述 | 示例值 |
---|---|---|---|---|
RegionId | string | 否 | 地域 ID。 说明
您可以调用 DescribeRegions 接口查看可用的地域 ID。
| cn-beijing |
JobId | integer | 是 | 任务 ID。 | 1 |
DBInstanceId | string | 是 | 实例 ID。 | gp-bp10g78o9807yv9h3 |
返回参数
示例
正常返回示例
JSON
格式
{
"RequestId": "B4CAF581-2AC7-41AD-8940-D56DF7AADF5B",
"JobId": "1",
"JobName": "test-job",
"JobDescription": "test_job",
"DataSourceId": "2",
"SrcColumns": [
"src_column_1"
],
"DestColumns": [
"dest_column_1"
],
"MatchColumns": [
"column_1"
],
"UpdateColumns": [
"column_1"
],
"Account": "test-account",
"Password": "pwd123",
"DestDatabase": "dest-db",
"DestSchema": "dest-schema",
"DestTable": "dest-table",
"WriteMode": "INSERT/UPDATE/MERGE",
"Mode": "basic/professional",
"JobConfig": "DATABASE: adbpgss_test\nUSER: adbpgss_test\nPASSWORD: adbpgssTest\nHOST: gp-xxx-master.gpdb.rds-aliyun-pre.rds.aliyuncs.com\nPORT: 5432\nKAFKA:\n INPUT:\n SOURCE:\n BROKERS: broker1:9092,broker2:9092,broker3:9092\n TOPIC: testtopic\n FALLBACK_OFFSET: earliest\n KEY:\n COLUMNS:\n - NAME: customer_id\n TYPE: int\n FORMAT: delimited\n DELIMITED_OPTION:\n DELIMITER: '|'\n VALUE:\n COLUMNS:\n - TYPE: integer\n NAME: l_orderkey\n - TYPE: integer\n NAME: l_partkey\n - TYPE: integer\n NAME: l_suppkey\n - TYPE: integer\n NAME: l_linenumber\n - TYPE: decimal\n NAME: l_quantity\n - TYPE: decimal\n NAME: l_extendedprice\n - TYPE: decimal\n NAME: l_discount\n - TYPE: decimal\n NAME: l_tax\n - TYPE: char\n NAME: l_returnflag\n - TYPE: char\n NAME: l_linestatus\n - TYPE: date\n NAME: l_shipdate\n - TYPE: date\n NAME: l_commitdate\n - TYPE: date\n NAME: l_receiptdate\n - TYPE: text\n NAME: l_shipinstruct\n - TYPE: text\n NAME: l_shipmode\n - TYPE: text\n NAME: l_comment\n FORMAT: delimited\n DELIMITED_OPTION:\n DELIMITER: '|'\n ERROR_LIMIT: 10\n OUTPUT:\n SCHEMA: adbpgss_test\n TABLE: write_with_insert_plaintext\n MODE: MERGE\n MATCH_COLUMNS:\n - l_orderkey\n - l_partkey\n - l_suppkey\n UPDATE_COLUMNS:\n - l_linenumber\n - l_quantity\n - l_extendedprice\n - l_discount\n - l_tax\n - l_returnflag\n - l_linestatus\n - l_shipdate\n - l_commitdate\n - l_receiptdate\n - l_shipinstruct\n - l_shipmode\n - l_comment\n MAPPING:\n - EXPRESSION: l_orderkey\n NAME: l_orderkey\n - EXPRESSION: l_partkey\n NAME: l_partkey\n - EXPRESSION: l_suppkey\n NAME: l_suppkey\n - EXPRESSION: l_linenumber\n NAME: l_linenumber\n - EXPRESSION: l_quantity\n NAME: l_quantity\n - EXPRESSION: l_extendedprice\n NAME: l_extendedprice\n - EXPRESSION: l_discount\n NAME: l_discount\n - EXPRESSION: l_tax\n NAME: l_tax\n - EXPRESSION: l_returnflag\n NAME: l_returnflag\n - EXPRESSION: l_linestatus\n NAME: l_linestatus\n - EXPRESSION: l_shipdate\n NAME: l_shipdate\n - EXPRESSION: l_commitdate\n NAME: l_commitdate\n - EXPRESSION: l_receiptdate\n NAME: l_receiptdate\n - EXPRESSION: l_shipinstruct\n NAME: l_shipinstruct\n - EXPRESSION: l_shipmode\n NAME: l_shipmode\n - EXPRESSION: l_comment\n NAME: l_comment\n COMMIT:\n MAX_ROW: 1000\n MINIMAL_INTERVAL: 1000\n CONSISTENCY: ATLEAST\n POLL:\n BATCHSIZE: 1000\n TIMEOUT: 1000\n PROPERTIES:\n group.id: testgroup",
"Status": "Running",
"ErrorMessage": "\"\"",
"CreateTime": "2019-09-08T16:00:00Z",
"ModifyTime": "2019-09-08T17:00:00Z",
"GroupName": "test_group",
"Consistency": "ATLEAST / EXACTLY",
"ErrorLimitCount": 5,
"FallbackOffset": "EARLIEST / LATEST",
"DataSourceName": "test_kafka"
}
错误码
访问错误中心查看更多错误码。