Query Local Secondary Index in DynamoDB Using Java (Guide w/ Code Examples)
![Rafal Wilinski](https://pbs.twimg.com/profile_images/1390706809548197895/SVCKpLNE_400x400.png)
Provided by Rafal Wilinski
The following example queries the MyTable
table using the FirstNameIndex
local secondary index. The key condition expression partitionKey = :val
is specified, along with a map of attribute values (expressionAttributeValues
) that includes the value "John" mapped to :val
. The query returns items in the table where the partitionKey
attribute is John
.
import com.amazonaws.services.dynamodbv2.AmazonDynamoDB; import com.amazonaws.services.dynamodbv2.AmazonDynamoDBClientBuilder; import com.amazonaws.services.dynamodbv2.model.AttributeValue; import com.amazonaws.services.dynamodbv2.model.QueryRequest; import com.amazonaws.services.dynamodbv2.model.QueryResult; public class QueryLocalSecondaryIndexExample { public static void main(String[] args) { AmazonDynamoDB client = AmazonDynamoDBClientBuilder.defaultClient(); Map<String, AttributeValue> expressionAttributeValues = new HashMap<>(); expressionAttributeValues.put(":val", new AttributeValue().withS("John")); QueryRequest queryRequest = new QueryRequest() .withTableName("MyTable") .withIndexName("FirstNameIndex") .withKeyConditionExpression("partitionKey = :val") .withExpressionAttributeValues(expressionAttributeValues); QueryResult result = client.query(queryRequest); result.getItems().forEach(item -> System.out.println(item)); } }
Similar Code Examples
- Delete Multiple Items in DynamoDB Using Java
- Batch Insert in DynamoDB Using Java
- Delete Record in DynamoDB Using Java
- Query Hash Key Only in DynamoDB Using Java
- GetItem in DynamoDB Using Java
- Update Multiple Items in DynamoDB Using Java
- Batch Save Using DynamoDB Mapper
- Batch Load Using DynamoDB Mapper
- Remove Item in DynamoDB Using Java
- Delete by Hashkey Using DynamoDB Mapper
- Remove Attribute in DynamoDB Using Java
- Delete in DynamoDB Using Java
- Get All Items from DynamoDB Using Java
- Insert in DynamoDB Using Java
- Delete Expression in DynamoDB Using Java
Spend less time in the AWS console, use Dynobase.
Try 7-day free trial. No credit card needed.
Product Features
DynamoDB Tools
DynamoDB Info
© 2024 Dynobase