[Bug]: Can not query JSON field

[zrg-team]

Is there an existing issue for this?

• [X] I have searched the existing issues

Environment

- Milvus version:
v2.3.0-dev
- Deployment mode(standalone or cluster):
STANDALONE
- MQ type(rocksmq, pulsar or kafka):    
DEFAULT
- SDK version(e.g. pymilvus v2.0.0rc2):
DEFAULT
- OS(Ubuntu or CentOS): 
MACOS
- CPU/Memory: 
- GPU: 
- Others:

Current Behavior

Query with JSON

Can not query

Expected Behavior

Query JSON field correctly

Steps To Reproduce

1. Add props field with JSON type
2. Add data { "ids": [1] }
3. Do query json_contains(props["ids"], [1])

Milvus Log

No response

Anything else?

No response

[xiaofan-luan]

it should be json_contains(props["ids"], 1) right?

[xiaofan-luan]

contains can not run with a array, only contains_any or contains_all

[zrg-team]

same result

[xiaofan-luan]

the expression is correct, what is 2.3.0-dev? the latest master branch?

[xiaofan-luan]

1. could you offer the querynode logs, we can. investigate on if there are any other errors?
2. did you ever try this could work in pymilvus?

[zrg-team]

@xiaofan-luan v2.3.0-dev is latest docker image for standalone version pymilvus I'm using nodejs sdk

yes let me provide some log from Milvus standalone docker

[xiaofan-luan]

we will keep investigating on this issue too

[yanliang567]

/assign @xiaocai2333 /unassign

[xiaocai2333]

@zrg-team The latest image does not have this problem. You can try again with the latest image.

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. Rotten issues close after 30d of inactivity. Reopen the issue with /reopen.

[zrg-team]

json_contains(references["table_definition_ids"], [120])

still not work

/reopen

[sre-ci-robot]

@zrg-team: Reopened this issue.

In response to this:

json_contains(references["table_definition_ids"], [120])

still not work

/reopen

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the kubernetes/test-infra repository.

[yanliang567]

/assign @elstic please help to check if it reproduces on v2.3.4

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. Rotten issues close after 30d of inactivity. Reopen the issue with /reopen.

[xiaocai2333]

json_contains(references["table_definition_ids"], [120])

still not work

/reopen

Do you want to search a list? If you just want to check whether it contains the element 120, the expression should be json_contains(references["table_definition_ids"], 120)

[xiaocai2333]

/assign @zrg-team /unassign

[Aries-ckt]

@xiaocai2333 @zrg-team Does Milvus version 2.2.9 support json_contains filter function?

[xiaocai2333]

@xiaocai2333 @zrg-team Does Milvus version 2.2.9 support json_contains filter function?

@Aries-ckt we support json_contains in v2.2.12. https://github.com/milvus-io/milvus/releases/tag/v2.2.12

[stale[bot]]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. Rotten issues close after 30d of inactivity. Reopen the issue with /reopen.