I have one issue . I have created delta table and vector search index from the delta table. For a particular query if I am doing similarity search then sometimes I am getting the documents and sometimes I am not getting any documents.
For example
# query="Explain about the content of R-CarAI_ACC_UM_172_RWDT_r0p30.xlsx"
# query="Explain about the content of AI"
query="Explain about the content of 022_R-CarAI_acc_IPEX_Interrupt_table_r0p30.xlsx"
# query="Explain about the tab named register description of R-CarAI-ACC_UM_172_RWDT_r0p30.xlsx"
# docs=vector_search.similarity_search(query_text=query,num_results=10,columns=["file_name","page_info"])
docs=vector_search.similarity_search(query_text=query,num_results=10,columns=["content_type", "content", "summary" , "file_name"],filters={"file_name": ["022_R-CarAI_acc_IPEX_Interrupt_table_r0p30.xlsx"]})
Then sometimes it is working and I can get the excel files and sometimes it is returning no docs. Do you have any idea why Am I having this abnormal behaviour of the vector search index?