Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Cannot create index in Azure DocumentDb with Mongodb protocol

Now I know that the Unique Index is not supported in DocumentDb, but why I cannot create a normal index using createIndex()? In mongo shell:

> db.product.createIndex({itemId:1})
{ "_t" : "OKMongoResponse", "ok" : 1 }

but the collection seems unchange:

> db.product.getIndexes()
[
{
    "v" : 1,
    "key" : {
        "_id" : 1
    },
    "name" : "_id_1",
    "ns" : "admin.product"
}
]

I also find Mongodb API Compatibility slide here. It told us that we can use createIndex function in mongodb to create non-unique index. Does anybody could tell me why?

like image 652
Mike Avatar asked Feb 27 '17 08:02

Mike


2 Answers

By default, DocumentDB with API for MongoDB automatically indexes all properties to reduce the setup complexity. We plan to release creating / updating indexes in the next couple releases.

like image 79
Andy Hoh Avatar answered Sep 28 '22 05:09

Andy Hoh


I think indexes are not supported at the moment (27/02/2017). Hopefully, future releases will support them.

like image 20
Toan Nguyen Avatar answered Sep 28 '22 06:09

Toan Nguyen