Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Query Result Order Difference Between MongoDB and AWS DocumentDB

0

Hello,

I am migrating a database from MongoDB to AWS DocumentDB. I have observed that when I query a collection with the same elements in both MongoDB and DocumentDB, the order of the results is different.

Is this a known behavior of query results on DocumentDB?

Thank you.

Topics
Database
Tags
Amazon DocumentDB
Language
English
asked 2 years ago320 views
1 Answer
1
Accepted Answer

Hello,

It's one of the function difference with MongoDB.

https://docs.aws.amazon.com/documentdb/latest/developerguide/functional-differences.html#functional-differences.result-ordering

Amazon DocumentDB does not guarantee implicit result sort ordering of result sets. To ensure the ordering of a result set, explicitly specify a sort order using sort().

EXPERT
answered 2 years ago
EXPERT
reviewed 2 years ago
  • rePost-User-2378131
    2 years ago

    So basically, since MongoDB does not guarantee implicit result sort ordering, the sort ordering in DocumentDB won't be the same as in MongoDB. Right?

  • Sivaraman Selvam EXPERT
    2 years ago

    yes, but you could explicitly specify a sort order using sort().

  • rePost-User-2378131
    2 years ago

    yea, unfortunately i need exactly the implicit sort order like in Mongo

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content