I would like to understand the execution process of ESQL queries in canvas.
The scenario is that I have 3 queries of simple counts.
SELCET COUNT(*) FROM MYINDEX WHERE FIELD=x
SELCET COUNT(*) FROM MYINDEX WHERE FIELD=y
SELCET COUNT(*) FROM MYINDEX WHERE FIELD=x or FIELD=y
The expected result is 3 counters. x, y and x+y.
However, I see that the third query does not equal the 2 first queries.
i.e results of ONE + TWO <> THREE
My assumption is that the queries do not run at the same time, hence the results are different.
- How do the queries execute in canvas?
- Is it possible to sync the queries so they will be executed at the same time?