Thread: Need help in writing OpenSearch multi-match query in Java?

Hi.

I am using OpenSearch to search text documents. I am using opensearch-java SDK to connect & index documents. I am able to write most of the basic CRUD operations. But I am stuck with writing multi-match query on a long data type. I have two fields avg_salary & max_salary. If anyone of them matches a number (suppose 100), I need to return the documents. Please help me with an example or sample Java code.

Thanks for the reply. I am sharing what I tried. I am trying to write multi match query as below:

		List<String> fields = new ArrayList<String>();
                fields.add("avg_salary");
                fields.add("max_salary");
		MultiMatchQuery query = new MultiMatchQuery.Builder().fields(fields).query(100)
				.build();

But query(100) is giving me compilation error. It only takes String as argument.

I found the issue. OpenSearch does not support multi match query on integer fields. Actually OpenSearch supports multi match query only on String fields. That is the reason the argument did not take integer value. I wrote multiple match queries & joined them using OR condition as suggested by this article https://www.w3spot.com/2022/11/how-t...y-in-java.html.