0

Well, my query is simple but I haven't seen (nor do I know if it exists) anything that does what I want.

I know how to make a Timestamp Query where I get a range of ordered data, the range would be from an initTimestamp to an endTimestamp.

However, I want to add a small complexity to the query (A filter??). Instead of returning ALL the items within that range, I want it to return items with a step/jump of X number of items.

That is, suppose that in that range I have 50 items, if I add a step of 10, it should return the items: [0, 9, 19, 29, 39, 49]

I hope the question is understood. I honestly don't know if it exists.

PS: I know that post-processing can be done, but the number of items is so enormous that a query of this style would be ideal.

Improve this question
3
  • 1
    No, this is not possible afaik. Commented Jan 30, 2024 at 12:42
  • my god... I have an extensive database table that is useless for certain cases, does that mean that I should create another table with more distant elements to be able to use that case? Will there be a solution for these cases without resorting to multiple calls to DynamoDB? Commented Feb 4, 2024 at 1:23
  • I haven't seen this 'step' capability in other databases but maybe I don't spend enough time in that space. Which databases provide arbitrary steps server-side through the result set? Commented Feb 4, 2024 at 1:43
Related questions
3
Range key with a timestamp. Query and pagination with DynamoDB
0
DynamoDB - Batch Update only if Partition Key and Range Key exists
0
How to sort DynamoDB query result without specifying range key value
Load 6 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.