1

Is NoSQL in general, and DynamoDB in particular, well suited to performing type queries, as compared to MySQL?

ykaganovich
  • 14,736
  • 8
  • 59
  • 96

1 Answers1

2

DynamoDB support only 2 index and can only be queried efficiently on these.

  1. hash key
  2. range key (optional)

Using DynamoDB to find the biggest values in a random "row" is not a good idea at all. Querying on a random row implies scanning the whole dataset which will cost you a lot of money.

Nonetheless, if your data is properly modeled, query method may be used to find the biggest range_key for a given hash_key

Here is how to proceed:

  • Set the has_key
  • Set no filter for the range_key
  • limit the result count to 1
  • scan the index backward
yadutaf
  • 6,840
  • 1
  • 37
  • 48