In Llamaindex, do we have support for

Any vector db can be used for auto retrieval

BUT I think elastic search doesn't support the more complex metadata filters yet. Needs a PR for that

we are looking for a database that supports full-text search and vector search that is not in memory. Do you have any suggestion that Llamaindex supports?

probably weaviate. Qdrant and pinecone support sparse search as well, which is similar to keyword

Thank you

If you're looking for a cloud service for this, Azure AI Search has full-text search, vector search, reranking, filters, etc. (in full disclosure, I work there :))