Retrieves the status and results of an asynchronous SQL query.
Try it now
Test
RAM authorization
Request syntax
GET /asyncsql/{queryId} HTTP/1.1
Path Parameters
|
Parameter |
Type |
Required |
Description |
Example |
| queryId |
string |
No |
Request parameters
|
Parameter |
Type |
Required |
Description |
Example |
| project |
string |
No |
||
| offset |
integer |
No |
||
| line |
integer |
No |
Response elements
|
Element |
Type |
Description |
Example |
| AsyncSqlResponseData |
Examples
Success response
JSON format
{
"id": "690C4F2A16FBD65C40000484_14",
"state": "FINISHED",
"AsyncSqlMetaPB": {
"result_rows": 12000,
"processed_rows": 10000000,
"elapsed_milli": 30000,
"cpu_sec": 0.2,
"cpu_cores": 10,
"progress": "Complete",
"keys": [
"[\"name\", \"age\", \"gender\"]"
]
},
"rows": [
[
"[\"Jimmy\", \"20\", \"male\"]"
]
],
"error_code": "InvalidQuery",
"error_message": "line 37:14: Column 'xyz' cannot be resolved"
}
Error codes
See Error Codes for a complete list.
Release notes
See Release Notes for a complete list.