Hi There, I have the following query

select a.id, b.id, sum(a.amt) amt, sum(b.amt) as amt_b

from tbla a

join (select id, ccy, sum(amt) from tblb group by id, ccy) b on b.id = a.id and b.ccy - a.ccy

group by a.id, b.id

I cant join these tables directly, and need to aggregate tblb as shown in the query above. It appears that Pinot is not returning all the id's from tblb (subquery), only a subset. May be the servers just respond partial results? Has anyone faced this, and appreciate any alternatives to get the complete result from the subquery, and execute the join.

Can you check if partial response flag is true? There might be some group trimming happening

Thanks @Jayesh Asrani - this fixed it.