[Feature]: The result of search, order by scalar field.

[zhoujiaqi1998]

Is there an existing issue for this?

• I have searched the existing issues

Is your feature request related to a problem? Please describe.

#33269
Create a vector for the count field, for example [count, 0]. Then search for the farthest verters and sort them based on similarity, but distance it is already overflowed。

Describe the solution you'd like.

example1:
search(vectors_to_search, "embeddings", search_params, limit=3000, output_fields=["embeddings","count"],expr="order by count")
example2:
select embeddings, count from table order by count

Describe an alternate solution.

No response

Anything else? (Additional Context)

No response

[xiaofan-luan]

how why do need to put count in a vector field?
does't seems to make sense?

[zhoujiaqi1998]

how why do need to put count in a vector field? does't seems to make sense?

为什么要在向量场中加入计数呢？ 似乎说不通？

search vector， Then order by count, but it seems that milvus does not have the ability to sort scalars.
So，create a count in a vector field and sort it by similarity.

[zhoujiaqi1998]

I need the ability to specify scalar field sort.

[RuslanLatsina]

@xiaofan-luan It will be great to have such feature to order by some fields

at least, it will be useful on query https://milvus.io/docs/v2.3.x/query.md

[xiaofan-luan]

@zhagnlu what do you think about add orderby into milvus?