I am struggling with filtering across two indices.
The example is as follows: In the first index (index_1), there are data with values. I take the data values, multiply them by 10 and store them in index_2 with the same ID as they have in index_1. Then new data arrives in index_1. I do not want to recalculate all values for index_2 again but I only want to do the calculation for the new arrived data. Therefore, I need a query that only returns the IDs of index_1 which are not in index_2.
The first index looks like
ID = 11, value_1 = 2.3
ID = 32, value_1 = 3.4
ID = 43, value_1 = 2.2
ID = 50, value_1 = 2.0
The second index looks like
ID = 11, value_2 = 23
ID = 23, value_2 = 34
ID = 43, value_2 = 22
The query should return ID = 50, value_1 = 2.0 from index_1 because ID50 is not in index_2.
I already tried a left join and a postfiltering, but as discussed in this topic, the postfiltering is not properly working.
Does anyone have an idea how to query this? It seems like a basic query but so far I didnt find any solution.