|
Parameter |
Type |
Description |
Example |
|---|---|---|---|
|
object |
The data structure for the response of an asynchronous SQL query. |
||
| id |
string |
The ID of the asynchronous SQL query. |
690C4F2A16FBD65C40000484_14 |
| state |
string |
The current execution state of the asynchronous SQL query. Valid values are:
RUNNING is a temporary state that indicates the SQL query is still running. You can read the results only when the state is FINISHED. The error_code and error_message parameters are valid only when the state is FAILED. |
FINISHED |
| AsyncSqlMetaPB |
object |
The metadata of the SQL query. |
|
| result_rows |
integer |
The total number of rows in the result. When you read the results, the offset value must not exceed this value. |
12000 |
| processed_rows |
integer |
The number of raw data rows processed. |
10000000 |
| elapsed_milli |
integer |
The SQL query running time in milliseconds. |
30000 |
| cpu_sec |
number |
The total CPU time consumed in seconds. |
0.2 |
| cpu_cores |
integer |
The number of CPU cores used. |
10 |
| progress |
string |
Indicates whether the SQL result is accurate. Valid values are:
|
Complete |
| keys |
array |
The names of the columns in the SQL result. The keys correspond one-to-one with the fields in the SELECT statement. |
|
|
string |
The column name. |
["name", "age", "gender"] |
|
| rows |
array |
The SQL result. Each element in the array is also an array that corresponds to a specific row of the result. |
|
|
array |
A row of the result. |
||
|
string |
A column of the result. |
["Jimmy", "20", "male"] |
|
| error_code |
string |
If the SQL query fails to execute, this parameter contains the specific error code. |
InvalidQuery |
| error_message |
string |
If the SQL query fails to execute, this parameter contains the specific error message. |
line 37:14: Column 'xyz' cannot be resolved |