Views details of asynchronous import and export tasks.
For more information about how to asynchronously submit an import and export tasks, see Asynchronously submit an import or export task.
Debugging
Request parameters
Parameter | Type | Required | Example | Description |
---|---|---|---|---|
Action | String | Yes | DescribeLoadTasksRecords |
The operation that you want to perform. Set the value to DescribeLoadTasksRecords. |
DBClusterId | String | Yes | am-bp********** |
The ID of a cluster. Note You can call the DescribeDBClusters operation to view the details (including cluster IDs) of all AnalyticDB for MySQL
clusters in the destination region.
|
StartTime | String | Yes | 2021-05-18T06:00:00Z |
The beginning of the time range to query. Specify the time in the yyyy-MM-ddTHH:mm:ssZ format. The time must be in UTC. Note We recommend that you set the query start time to any point in time within 30 days.
|
EndTime | String | Yes | 2021-05-18T06:30:00Z |
The end of the time range to query. The end time must be later than the start time. Specify the time in the yyyy-MM-ddTHH:mm:ssZ format. The time must be in UTC. |
DBName | String | No | adb_demo |
The name of the database involved in the import or export task. |
PageSize | Integer | No | 30 |
The number of entries to return on each page. Default value: 30. Valid values:
|
PageNumber | Integer | No | 1 |
The number of the page to return. The value must be an integer that is greater than 0. Default value: 1. |
Order | String | No | [{"Field":"CreateTime", "Type":"desc"}] |
The order in which to sort the retrieved records by field. Specify the field used
to sort the retrieved records and the order type in the JSON format. Example: Note
|
State | String | No | FINISH |
The status of the asynchronous import or export task to be queried. Valid values:
|
Response parameters
Parameter | Type | Example | Description |
---|---|---|---|
TotalCount | String | 1 |
The total number of merged streams. |
PageSize | String | 30 |
The number of entries returned on the current page. |
RequestId | String | C60B05DB-2B77-421A-98E9-92C20E****** |
The ID of the request. |
PageNumber | String | 1 |
The page number of the returned page. |
DBClusterId | String | am-bp********** |
The ID of a cluster. |
LoadTasksRecords | Array of LoadTaskRecord |
An array that consists of the information of tasks. |
|
Sql | String | insert overwrite into courses_external_table\nselect * from courses |
The SQL statement used in the task. |
State | String | FINISH |
The status of the task. |
CreateTime | String | 2021-05-18 18:47:27.0 |
The start time of the task. It is accurate to milliseconds. The time is in the yyyy-MM-ddTHH:mm:ss.SSSZ format. |
DBName | String | adb_demo |
The name of the database involved in the task. |
ProcessID | String | 2021051818472717201616624903453****** |
The ID of the process. |
UpdateTime | String | 2021-05-18 18:47:31.0 |
The time when the task status was updated. It is accurate to milliseconds. The time is in the yyyy-MM-ddTHH:mm:ss.SSSZ format. |
JobName | String | 2021051818472717201616624903453****** |
The ID of the task. |
ProcessRows | Long | 6 |
The number of rows that are processed in the task. |
Examples
Sample requests
http(s)://ads.aliyuncs.com/?&Action=DescribeLoadTasksRecords
&DBClusterId=am-bp**********
&StartTime=2021-05-18T06:00:00Z
&EndTime=2021-05-18T06:30:00Z
&Common request parameters
Sample success responses
XML
format
HTTP/1.1 200 OK
Content-Type:application/xml
<DescribeLoadTasksRecordsResponse>
<TotalCount>1</TotalCount>
<LoadTasksRecords>
<ProcessRows>6</ProcessRows>
<State>FINISH</State>
<CreateTime>2021-05-18 18:47:27.0</CreateTime>
<JobName>2021051818472717201616624903453******</JobName>
<UpdateTime>2021-05-18 18:47:31.0</UpdateTime>
<DBName>adb_demo</DBName>
<ProcessID>2021051818473117201616624903453******</ProcessID>
<Sql> insert overwrite into courses_external_table
select * from courses</Sql>
</LoadTasksRecords>
<RequestId>C60B05DB-2B77-421A-98E9-92C20E******</RequestId>
<PageSize>30</PageSize>
<PageNumber>1</PageNumber>
<DBClusterId>am-bp**********</DBClusterId>
</DescribeLoadTasksRecordsResponse>
JSON
format
HTTP/1.1 200 OK
Content-Type:application/json
{
"TotalCount" : 1,
"LoadTasksRecords" : [ {
"ProcessRows" : 6,
"State" : "FINISH",
"CreateTime" : "2021-05-18 18:47:27.0",
"JobName" : "2021051818472717201616624903453******",
"UpdateTime" : "2021-05-18 18:47:31.0",
"DBName" : "adb_demo",
"ProcessID" : "2021051818473117201616624903453******",
"Sql" : " insert overwrite into courses_external_table\nselect * from courses"
} ],
"RequestId" : "C60B05DB-2B77-421A-98E9-92C20E******",
"PageSize" : 30,
"PageNumber" : 1,
"DBClusterId" : "am-bp**********"
}
Error codes
HttpCode | Error code | Error message | Description |
---|---|---|---|
404 | InvalidDBCluster.NotFound | The DBClusterId provided does not exist in our records. | The error message returned because the specified cluster ID does not exist. Check whether the cluster ID is valid. |
For a list of error codes, visit the API Error Center.