Hi, I need a help on Elasticsearch query solution for an sql query select t1.* from (select * from abc where event=2003) as t1 inner join (select * from abc where event =4012) as t2 on t1.c_id=t2.c_id where t1.balance+t2.balance=0 Is this type of query in elastic search achievable

Query that sum balance of different event

Nikhil_Nambiar (Nikhil Nambiar) November 20, 2018, 2:25am 3

I have rephrased the query and I have posted till which point I got success and where it's breaking in below link

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.