GetStatementResult - AnalyticDB - Alibaba Cloud Documentation Center

This topic is generated by a machine translation engine without any human intervention. ALIBABA CLOUD DOES NOT GUARANTEE THE ACCURACY OF MACHINE TRANSLATED CONTENT. To request a human-translated version of this topic or provide feedback on this translation, please include it in the feedback form.

Get Asynchronous SQL Execution Result

Debugging

You can run this interface directly in OpenAPI Explorer, saving you the trouble of calculating signatures. After running successfully, OpenAPI Explorer can automatically generate SDK code samples.

Debug

Authorization information

The following table shows the authorization information corresponding to the API. The authorization information can be used in the Action policy element to grant a RAM user or RAM role the permissions to call this API operation. Description:

Operation: the value that you can use in the Action element to specify the operation on a resource.
Access level: the access level of each operation. The levels are read, write, and list.
Resource type: the type of the resource on which you can authorize the RAM user or the RAM role to perform the operation. Take note of the following items:
- For mandatory resource types, indicate with a prefix of * .
- If the permissions cannot be granted at the resource level, All Resources is used in the Resource type column of the operation.
Condition Key: the condition key that is defined by the cloud service.
Associated operation: other operations that the RAM user or the RAM role must have permissions to perform to complete the operation. To complete the operation, the RAM user or the RAM role must have the permissions to perform the associated operations.

Operation	Access level	Resource type	Condition key	Associated operation
gpdb:GetStatementResult	get	All Resources ``	none	none

Request parameters

Parameter	Type	Required	Description	Example
DBInstanceId	string	Yes	Instance ID. Can be obtained by calling DescribeDBInstances.	gp-xxxxxxxxx
RegionId	string	Yes	Region ID where the instance is located.	cn-beijing
SecretArn	string	Yes	Access credential. Created through the CreateSecret interface. Note When accessing this interface with a sub-account, the sub-account must have the UseSecret or GetSecretValue permission for this SecretArn.	acs:gpdb:cn-beijing:1033**:secret/testsecret-eG2AQGRIwQ0zFp4VA7mYL3uiCXTfDQbQ
Database	string	No	Database name.	test
Id	string	Yes	Task ID for asynchronous SQL execution.	9A920F47-416A-4044-817C-7C2A72AD16D3

Response parameters

Parameter	Type	Description	Example
	object
RequestId	string	Request ID.	ABB39CC3-4488-4857-905D-2E4A051D0521
Message	string	Return message.	success
Status	string	API execution status, with values as follows: false: Execution failed. true: Execution succeeded.	success
Data	object	The result of the asynchronous call.
Records	array	Multiple rows of data.
Records	array	A single row of data.
Record	Field	A single data item.
ColumnMetadata	array	List of column metadata.
ColumnMetadata	ColumnMetadata	Column metadata.
TotalNumRows	long	Total number of entries.	10

Examples

Sample success responses

JSONformat

{
  "RequestId": "ABB39CC3-4488-4857-905D-2E4A051D0521",
  "Message": "success",
  "Status": "success",
  "Data": {
    "Records": {
      "Records": [
        {
          "Record": [
            {
              "BlobValue": "",
              "BooleanValue": true,
              "DoubleValue": 0,
              "IsNull": true,
              "LongValue": 0,
              "StringValue": ""
            }
          ]
        }
      ]
    },
    "ColumnMetadata": {
      "ColumnMetadata": [
        {
          "Name": "",
          "DataType": "",
          "ColumnDefault": "",
          "MaxLength": 0,
          "Nullable": true,
          "SchemaName": "",
          "TableName": "",
          "IsCaseSensitive": true,
          "IsCurrency": true,
          "IsSigned": true,
          "Precision": 0,
          "Scale": 0,
          "IsPrimaryKey": true,
          "Comment": "",
          "UdtName": ""
        }
      ]
    },
    "TotalNumRows": 10
  }
}

Error codes

For a list of error codes, visit the Service error codes.