I already created an Index for MongoDB vCore, but when I query that database, I get the error 'Similarity index was not found for a vector similarity search query'

Question

Here is my code for creating the collection. When I run it, I see that an index was created. However, when I try to query the database using a vector, it says that there is no index, as in the error above:

import pymongo
import openai
from openai import AzureOpenAI
import json
import ast
import re

vector_mongo_client = pymongo.MongoClient("<credentials")
vector_db = vector_mongo_client["WCS_vectordb"]
vector_collection = vector_db["WCS_parts_vector_collection"]

vector_db.command({
  'createIndexes': 'WCS_parts_vector_collection',
  'indexes': [
    {
      'name': 'ProductGPT_vector_index',
      'key': {
        "Vector": "cosmosSearch"
      },
      'cosmosSearchOptions': {
        'kind': 'vector-ivf',
        'numLists': 800,
        'similarity': 'COS',
        'dimensions': 1536
      }
    }
  ]
})


index = {
    'vectors': 'Vector',
    'type': 'vector-ivf',
    'params':{
        'dim': 1536,
        'metric': 'cosine',
        'numLists': 1000
    }
}

for index in vector_collection.list_indexes():
    print(index)

Answer 1

@Tyler Suard I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

Issue: You have created an index for MongoDB vCore, but when you query the database using a vector, you are getting the error "Similarity index was not found for a vector similarity search query."

Solution: As you mentioned you have set the wrong database and collection and by correcting your issue got resolved.

If you have any other questions or are still running into more issues, please let me know.

Please remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution.

Regards

Geetha

Answer 2

I was trying to connect to the wrong database and collection.