Hello, i ask for your help with complex queries,
Two indices in elasticsearch
I want to select all gateway_names within one index that are not existent in the other.
SELECT * FROM index_large a LEFT JOIN index_small e ON (a.gateway_name = e.gateway_name) WHERE index_small .id is NULL
Similiar to (just the filter addition of all the null values):
I do not retain all null-values, but all values. (The filter doesn’t seem to work)
Has someone a different approach or an idea what is wrong with mine?
Documentation of complex queries: https://opendistro.github.io/for-elasticsearch-docs/docs/sql/complex/
Thank you in advance!