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
.
This is an asynchronous operation using the standard naming convention for .NET 4.5 or higher. For .NET 3.5 the operation is implemented as a pair of methods using the standard naming convention of BeginExecuteStatement and EndExecuteStatement.
Namespace: Amazon.DynamoDBv2
Assembly: AWSSDK.DynamoDBv2.dll
Version: 3.x.y.z
public virtual Task<ExecuteStatementResponse> ExecuteStatementAsync( ExecuteStatementRequest request, CancellationToken cancellationToken )
Container for the necessary parameters to execute the ExecuteStatement service method.
A cancellation token that can be used by other objects or threads to receive notice of cancellation.
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:
Supported in: 8.0 and newer, Core 3.1
.NET Standard:
Supported in: 2.0
.NET Framework:
Supported in: 4.5 and newer