when running this query: ```select s_id, count(*) ...
# troubleshooting
r
when running this query:
Copy code
select s_id, count(*) from shipmentMerged_final_1 group by s_id having count(*) > 1
in multi-stage engine I dont see any result but without using multi-stage engine I am seeing multiple s_id
j
Can you share more context? What result did you get when running single-stage engine?
r
I was getting the count as 2 and 3 for the upsert table in which I should be getting 1 only, but when run with multi-stage engine it was not showing anything
j
Is this an upsert table? Check if the segments are partitioned properly by looking at the segment metadata stored in ZK