Is it possible to order dynamodb results by a sort function?

Question

Say I have a function:

function sorter(a,b)

And it has a rule for defining if row value a is "bigger" than row value b (so returns 1 if a>b and -1 if row value a is "smaller" than bigger than row value b.

Can I sort the results by this function?

An example could be the "log" math function function (bad example because it's monotonic increasing), with a and b being positive integers.

The only way I can think of doing this is by simply getting all the rows matching my query and then looping through them one by one and using my sorter function to sort them. The data set has returned > 30k rows in my example queries and I am estimating up to 100k rows could be returned in the worst case scenario. So I would prefer not to loop through the results (this is for a web application and needs to respond in realtime).

Edit: I should add, the sorter function is time dependent and features variables that change value over time. So precomputing is not an option.

JaredHatfield · Accepted Answer · 2015-07-19 00:55:10Z

2

When querying DynamoDB the records will be sorted by the range key and you can decide to sort ascending or descending. It is not possible to specify any other sort order with DynamoDB.

Sorting records by any other method would need to be performed by your application code.

answered Jul 19, 2015 at 0:55

JaredHatfield

6,6713 gold badges32 silver badges33 bronze badges

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

Collectives™ on Stack Overflow

Is it possible to order dynamodb results by a sort function?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related