I am new to open search, I am working on below use case. I am using server side pagination. we are using open search as search engine, when filter query matches more than 10000 results, we are not able to fetch results.
Example if we have 11000 documents matching query but when we pass page no 101 and page size 100. I am expecting to return documents from 10000 to 10100. but i am getting error on open search because of default limit of 10000.
I can not increase this considering limit increase will lead to more load on cluster.
Can some one assist us on how to solve this ?

I’m currently using version 2.17.1 and referring to this official documentation. OpenSearch – Query DSL – Joining Queries – Nested query – Multi-level nested queries.

I have an app where I index data in OpenSearch. The data model is largely defined by the end users and not by myself. So, when a user says that they have a “string” field, I index it both as a text and keyword field in OpenSearch because I don’t know whether it’s a short, enum-style string or long-form text. So my field mappings look like:

I have an app where I index data in OpenSearch. The data model is largely defined by the end users and not by myself. So, when a user says that they have a “string” field, I index it both as a text and keyword field in OpenSearch because I don’t know whether it’s a short, enum-style string or long-form text. So my field mappings look like:

Have the following documents in opensearch:

Currently using elastic search Serverless, I have a field called street number , currently it’s stored as a text. It contains values which are both string and text:
[100, 101A, 102A, 103, 105-B, 150,]
My use case is I want to use a range query to get all street numbers between 100 & 110. It should output all values including the string values.
My questions is

I’m using Opensearch to retrieve some documents from my index. Here is the query I’m using:

I’m working with an OpenSearch database and I need to pull some data that I would use a JOIN to get from an SQL database but I’m not sure the best way to get it from OpenSearch.

I am using OpenSearch version 7.10.2 and encountering an issue with the match_phrase_prefix query on certain asset numbers. My asset_number field is analyzed using a lowercase analyzer. Here is the detailed setup:

I’m facing an issue with retrieving documents using a prefix query in Elasticsearch. Here’s the scenario: