Query that sum balance of different event

(Nikhil Nambiar) #1

I need a help on Elasticsearch query solution for an sql query

select t1.*
(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