I need to filter results from my indices based on this scenario: Select * from TblName where status='ERROR' not in (select * from TbleName where status='OK' ) I am unable to get desired results using must, must not etc.

SQL Query with "NOT IN" keyword replacement in ES

W.anjum (Waseem Anjum) December 5, 2018, 10:23am 6

It doesn't matter its SQL or elastic search query. I need a solution for this logic:
ES Logic

Topic		Replies	Views
SQL Queries Elasticsearch	2	350	October 3, 2019
Help to convert SQL to ElasticSearch Elasticsearch	6	1822	October 27, 2017
SQL to ES Query Elasticsearch	3	327	May 18, 2018
Elasticsearch Query with subquery Elasticsearch	1	274	November 10, 2022
NOT IN replacement in elasticsearch sql query Elasticsearch	4	19	August 6, 2024

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

SQL Query with "NOT IN" keyword replacement in ES

Related topics