DynamoDB PartiQL Unsupported clause: LIMIT in console

Question

Hi there, according to the [documentation ](https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_ExecuteStatement.html#API_ExecuteStatement_RequestSyntax) LIMIT is an optional parameter for DynamoDB PartiQL .  However when I attempt to use it in the console by entering a statement like `select * from "USER" limit 1` I receive an error "ValidationException: Unsupported clause: LIMIT "

Would be good if the console supported this since the API does

Leeroy Hannigan · Answer

Hi, 
This is expected behaviour as the `Limit` parameter does not belong to the `Statement` but rather the request body:
```
{
   "ConsistentRead": boolean,
   "Limit": number,
   "NextToken": "string",
   "Parameters": [ 
     ...
   ],
   "ReturnConsumedCapacity": "string",
   "Statement": "string"
}
```
```
  client.executeStatement({
    Statement: statement, 
    Limit: 1
  })
```

For that reason, Limit is not currently available for the Web Console.

DynamoDB PartiQL Unsupported clause: LIMIT in console

Ajoutez votre réponse

Contenus pertinents