What are the operators supported by AWS Opensearch (like greater than, equals ...)

AWS OpenSearch supports a variety of operators for querying and filtering data. Here's a list of the supported operators:

1. The supported operators in AWS OpenSearch include:

• Equals (=)
• Not equals (!=)
• Greater than (>)
• Greater than or equal to (>=)
• Less than (<)
• Less than or equal to (<=)
• IN (for checking if a value is in a list)

2. Regarding the "Exists" operator, while it is not explicitly mentioned in the context of AWS OpenSearch, it is a common operator in many database systems. However, based on the information provided in the sources, there is no specific mention of an "Exists" operator for AWS OpenSearch.

It's worth noting that the exact set of operators may vary depending on the specific context or query language being used within OpenSearch. For the most up-to-date and comprehensive information, it's always best to consult the official AWS OpenSearch documentation or contact AWS support.
Sources
Supported OpenSearch SQL commands and functions - Amazon OpenSearch Service
Configure and customize queries and response generation - Amazon Bedrock