Query.java - AWS Code Sample


Query.java demonstrates how to query a DynamoDB table.

/* Copyright 2010-2019 Amazon.com, Inc. or its affiliates. All Rights Reserved. This file is licensed under the Apache License, Version 2.0 (the "License"). You may not use this file except in compliance with the License. A copy of the License is located at http://aws.amazon.com/apache2.0/ This file is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. */ package aws.example.dynamodb; 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.ProvisionedThroughput; import com.amazonaws.services.dynamodbv2.model.QueryRequest; import com.amazonaws.services.dynamodbv2.model.QueryResult; import com.amazonaws.services.dynamodbv2.model.AmazonDynamoDBException; import java.util.HashMap; import com.amazonaws.AmazonServiceException; /** * Query a DynamoDB table. * * Takes the name of the table to update, the read capacity and the write * capacity to use. * * This code expects that you have AWS credentials set up per: * http://docs.aws.amazon.com/java-sdk/latest/developer-guide/setup-credentials.html */ public class Query { public static void main(String[] args) { final String USAGE = "\n" + "Usage:\n" + " Query <table> <partitionkey> <partitionkeyvalue>\n\n" + "Where:\n" + " table - the table to put the item in.\n" + " partitionkey - partition key name of the table.\n" + " partitionkeyvalue - value of the partition key that should match.\n\n" + "Example:\n" + " Query GreetingsTable Language eng \n"; if (args.length < 3) { System.out.println(USAGE); System.exit(1); } String table_name = args[0]; String partition_key_name = args[1]; String partition_key_val = args[2]; String partition_alias = "#a"; System.out.format("Querying %s", table_name); System.out.println(""); final AmazonDynamoDB ddb = AmazonDynamoDBClientBuilder.defaultClient(); //set up an alias for the partition key name in case it's a reserved word HashMap<String,String> attrNameAlias = new HashMap<String,String>(); attrNameAlias.put(partition_alias, partition_key_name); //set up mapping of the partition name with the value HashMap<String, AttributeValue> attrValues = new HashMap<String,AttributeValue>(); attrValues.put(":"+partition_key_name, new AttributeValue().withS(partition_key_val)); QueryRequest queryReq = new QueryRequest() .withTableName(table_name) .withKeyConditionExpression(partition_alias + " = :" + partition_key_name) .withExpressionAttributeNames(attrNameAlias) .withExpressionAttributeValues(attrValues); try { QueryResult response = ddb.query(queryReq); System.out.println(response.getCount()); } catch (AmazonDynamoDBException e) { System.err.println(e.getErrorMessage()); System.exit(1); } System.out.println("Done!"); } }

Sample Details

Service: dynamodb

Last tested: 2018-01-15

Author: soo-aws

Type: full-example