AWS services or capabilities described in AWS Documentation may vary by region/location. Click Getting Started with Amazon AWS to see specific differences applicable to the China (Beijing) Region.
This operation allows you to perform reads and singleton writes on data stored in DynamoDB, using PartiQL.
For PartiQL reads (SELECT statement), if the total number of processed items
exceeds the maximum dataset size limit of 1 MB, the read stops and results are returned
to the user as a LastEvaluatedKey value to continue the read in a subsequent
operation. If the filter criteria in WHERE clause does not match any data,
the read will return an empty result set.
A single SELECT statement response can return up to the maximum number of items
(if using the Limit parameter) or a maximum of 1 MB of data (and then apply any filtering
to the results using WHERE clause). If LastEvaluatedKey is present in
the response, you need to paginate the result set. If NextToken is present,
you need to paginate the result set and include NextToken.
For .NET Core this operation is only available in asynchronous form. Please refer to ExecuteStatementAsync.
Namespace: Amazon.DynamoDBv2
Assembly: AWSSDK.DynamoDBv2.dll
Version: 3.x.y.z
public abstract ExecuteStatementResponse ExecuteStatement( ExecuteStatementRequest request )
Container for the necessary parameters to execute the ExecuteStatement service method.
| Exception | Condition |
|---|---|
| ConditionalCheckFailedException | A condition specified in the operation could not be evaluated. |
| DuplicateItemException | There was an attempt to insert an item with the same primary key as an item that already exists in the DynamoDB table. |
| InternalServerErrorException | An error occurred on the server side. |
| ItemCollectionSizeLimitExceededException | An item collection is too large. This exception is only returned for tables that have one or more local secondary indexes. |
| ProvisionedThroughputExceededException | Your request rate is too high. The Amazon Web Services SDKs for DynamoDB automatically retry requests that receive this exception. Your request is eventually successful, unless your retry queue is too large to finish. Reduce the frequency of requests and use exponential backoff. For more information, go to Error Retries and Exponential Backoff in the Amazon DynamoDB Developer Guide. |
| RequestLimitExceededException | Throughput exceeds the current throughput quota for your account. Please contact Amazon Web Services Support to request a quota increase. |
| ResourceNotFoundException | The operation tried to access a nonexistent table or index. The resource might not be specified correctly, or its status might not be ACTIVE. |
| TransactionConflictException | Operation was rejected because there is an ongoing transaction for the item. |
.NET Framework:
Supported in: 4.5, 4.0, 3.5