How to fetch multiple rows from DynamoDB using a non primary key

Question

select * from tableName where columnName="value";

How can I fetch a similar result in DynamoDB using java, without using primary key as my attribute (Need to group data based on a value for a particular column).

I have gone through articles regarding getbatchitems, QuerySpec but all these require me to pass the primary key.

Can someone give a lead here?

Brian Winant · Accepted Answer · 2018-07-24 23:26:54Z

1

Short answer is you can't. Whenever you use the Query or GetItem operations in DynamoDB you must always supply the table or index primary key.

You have two options:

Perform a Scan operation on the table and filter by columnName="value". However this requires DynamoDB to look at every item in the table so it is likely to be slow and expensive.
Add a Global Secondary Index to your table. This will require you to define a primary key for the index that contains the columnName you want to query

answered Jul 24, 2018 at 23:26

Brian Winant

3,03517 silver badges19 bronze badges

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

1 Comment

Mohanty Over a year ago

Thanks. Yes, I did not want to use 'Scan' for that reason. I will go with the 2nd option.

Collectives™ on Stack Overflow

How to fetch multiple rows from DynamoDB using a non primary key

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related