How to create a compound text index in MongoDB using java driver

Question

I have a requirement to create a compound text index on two fields. I am using java driver. I found examples on how to create index for compound fields but not for text indexes. How can I achieve this using java driver

Sylvain Leroux · Accepted Answer · 2015-05-23 14:37:28Z

3

Something along the lines of the following code should do the trick (untested):

BasicDBObject obj = new BasicDBObject();
obj.put("name", 1);
obj.put("comment", "text");
collection.ensureIndex(obj);

answered May 23, 2015 at 14:37

Sylvain Leroux

52.4k8 gold badges114 silver badges136 bronze badges

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

Comments

Youssef NAIT · Accepted Answer · 2021-09-13 15:50:55Z

0

I would recommand the following using the driver DSL which exists since version 3.1 of the java driver, it can also be used to specify Index options such as language, background etc ... :

    MongoCollection<Document> myCollection = db.getCollection("my-collection");
    myCollection.createIndex(
            Indexes.compoundIndex(
              Indexes.ascending("name"),
              Indexes.text("comment")),
            new IndexOptions()                                                             
              .defaultLanguage("es")
              .background(true));

answered Sep 13, 2021 at 15:50

Youssef NAIT

1,54014 silver badges28 bronze badges

Collectives™ on Stack Overflow

How to create a compound text index in MongoDB using java driver

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related