Query that sum balance of different event


(Nikhil Nambiar) #1

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


(Jaspreet Singh) #2

Can you rephrase your requirement in non sql way?


(Nikhil Nambiar) #3

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