Get count of column values in DynamoDB using AWS Java SDK

Question

I have a DynamoDB with items as follows

ID     TotalCount   SuccessCount   FailedCount

1         10            5              5

1         5             3              2

1         5             2              3

Using DynamoDB AWS Java SDK (e.g using DynamoDBQueryExpression or DynamoDBScanExpression or any other DynamoDB API), how can I get count of TotalCount, SuccessCount and FailedCount for ID = 1.

Equivalent SQL like query will be as follows.

SELECT COUNT(TotalCount), COUNT(SuccessCount), COUNT(FailedCount)
FROM TABLE
WHERE ID = 1;

Any help will be appreciated.

jarmod · Accepted Answer · 2019-10-13 20:50:44Z

1

DynamoDB doesn't natively support this type of aggregation and it also does not support SQL so you can't use any SQL queries. You'd have to scan/query the table, retrieve the relevant rows, and then sum the columns in your application.

If column aggregations are really important to your application and you're committed to NoSQL then you might want to try to maintain them independently but it's a difficult problem to solve.

Depending on your programming language, there may also be third-party options like RazorSQL or DynamoDB.SQL.

edited Oct 13, 2019 at 20:50

answered Oct 13, 2019 at 20:26

jarmod

79.8k18 gold badges132 silver badges137 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Matthew Pope Over a year ago

MongoDB doesn’t natively support SQL, but it supports the OP’s query. The problem is not the lack of SQL—it is that DynamoDB’s query engine doesn’t support server-side aggregations of any kind.

jarmod Over a year ago

@MatthewPope I didn't mean to connect those two statements as cause and effect. I'll clarify.

Collectives™ on Stack Overflow

Get count of column values in DynamoDB using AWS Java SDK

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related