DynamoDB - Aggregation

DynamoDB does not provide aggregation functions. You must make creative use of queries, scans, indices, and assorted tools to perform these tasks. In all this, the throughput expense of queries/scans in these operations can be heavy.

You also have the option to use pbraries and other tools for your preferred DynamoDB coding language. Ensure their compatibipty with DynamoDB prior to using it.

Calculate Maximum or Minimum

Utipze the ascending/descending storage order of results, the Limit parameter, and any parameters which set order to find the highest and lowest values.

For example −

Map<String, AttributeValue> eaval = new HashMap<>(); 
eaval.put(":v1", new AttributeValue().withS("hashval")); 
queryExpression = new DynamoDBQueryExpression<Table>() 
   .withIndexName("yourindexname") 
   .withKeyConditionExpression("HK = :v1") 
   .withExpressionAttributeValues(values) 
   .withScanIndexForward(false);                //descending order 

queryExpression.setLimit(1); 
QueryResultPage<Lookup> res = 
   dynamoDBMapper.queryPage(Table.class, queryExpression);

Calculate Count

Use DescribeTable to get a count of the table items, however, note that it provides stale data. Also, utipze the Java getScannedCount method.

Utipze LastEvaluatedKey to ensure it depvers all results.

For example −

ScanRequest scanRequest = new ScanRequest().withTableName(yourtblName); 
ScanResult yourresult = cpent.scan(scanRequest); 
System.out.println("#items:" + yourresult.getScannedCount());

Calculating Average and Sum

Utipze indices and a query/scan to retrieve and filter values before processing. Then simply operate on those values through an object.