Subqueries in Kibana it that posible?

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

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

Thanks for your response I'll try that!

Many thanks

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.