pymilvus icon indicating copy to clipboard operation
pymilvus copied to clipboard

[QUESTION]: Search multiple collections

Open PeterPilley opened this issue 3 years ago • 20 comments

Is there an existing issue for this?

  • [X] I have searched the existing issues

What is your question?

is it possible to search multiple collections in one search. I know in the library we have to nominate a collection and then perform a query on that but I was hoping that there was a way to search 2 from one query.

Anything else?

No response

PeterPilley avatar Aug 04 '22 11:08 PeterPilley

Just be curious what scenario is your case?

Search one vector in two collections from one request, what kind of result are you expecting to return from Milvus?

shanghaikid avatar Aug 04 '22 11:08 shanghaikid

So we have a collection that is a base collection that is not updated by our users and then a collection that they can update.

For a query we do them in series however it would be awesome if we could search multiple collections that have a similar schema

Does that make sense.?

PeterPilley avatar Aug 04 '22 12:08 PeterPilley

@xiaofan-luan any thoughts?

shanghaikid avatar Aug 04 '22 12:08 shanghaikid

so you want to

So we have a collection that is a base collection that is not updated by our users and then a collection that they can update.

For a query we do them in series however it would be awesome if we could search multiple collections that have a similar schema

Does that make sense.?

if copying one query request and send them to different collections, is it working for you? do you expect multiple search results or one combined search result?

yanliang567 avatar Aug 05 '22 07:08 yanliang567

Hi Sorry I thought I had replied to this, doing multiple requests is okay but it would be great to have one combined search result if multiple collections are specified and provided they have the same or similar enough schema

PeterPilley avatar Aug 18 '22 03:08 PeterPilley

This might not a common demands since I thought different collection may have total schema and it's hard to search among collections. If they are all same schema why not use multiple partition instead?

xiaofan-luan avatar Aug 18 '22 07:08 xiaofan-luan

Can you explain the multiple partitions?

We have at the moment 2 (we will have more in the future) collections with similar schema, one is read only for the user the other is read-write.

PeterPilley avatar Aug 18 '22 23:08 PeterPilley