Create geospatial and type index together in MongoDB?

Question

I want to use two indexes from different index types (2dsphere and text) by using this command :

db.mycoll.createIndex({"@geolocationable":"2dsphere",name:"text"})

but I get the following Error:

"errmsg" : "bad index key pattern { @geolocationable: \"2dsphere\", name: \"text\" }: Can't use more than one index plugin for a single index."

I read MongoDB Text and 2D compound index but I'm not sure that why I can't create 2dsphere and text index in one collection.

I don't mean that I want to use of both indexes in one query while I want to create this indexes in order to use from them in separate queries individually

4J41 · Accepted Answer · 2016-09-24 15:23:41Z

0

Edit: Modified to answer the updated question.

If both the fields are to be used in queries separately, then you can create 2 different indexes instead of the compound index.

The geospatial index:

db.mycoll.createIndex({"@geolocationable":"2dsphere"})

The text index:

db.mycoll.createIndex({name:"text"})

Also, from docs note that

A collection can have at most one text index.

While creating a compound index, text index can not be grouped with a multi or geospatial index. It is a compound index restriction.

From the docs:

A compound text index cannot include any other special index types, such as multi-key or geospatial index fields.

However, if you are not going to perform case insensitive searches on name field, you can create the compound index with a normal index instead of a text index.

db.mycoll.createIndex({"@geolocationable":"2dsphere",name:1})

edited Sep 24, 2016 at 15:23

answered Sep 24, 2016 at 14:28

4J41

5,1051 gold badge31 silver badges43 bronze badges

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

2 Comments

Mr White Over a year ago

I've updated the question I don't want to use of both indexes in one query

4J41 Over a year ago

@Mobin: Updated my answer

Collectives™ on Stack Overflow

Create geospatial and type index together in MongoDB?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related