Subqueries in Kibana it that posible?

Elastic Stack Kibana
1

Hi
I'm new in Elastic and do not know if it even can be possible.
I'd like to perform this "query" i kibana.

Select col1 from table1 t1 where NOT exists (select col1 from table1 t2 where t1.col1=t2.col1 and t1.date = t2.date)

Many thanks in advance for your help

2

Hello,

We are in process of getting SQL implemented (esql).
So this works now - Select col1 from table1 t1 where NOT exists
and you can see if you make a run time field for this select col1 from table1 t2 where t1.col1=t2.col1 and t1.date = t2.date and see if your query works?

Thanks,
Bhavya

3

Thanks for your response I'll try that!

Many thanks