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:

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