another issue:

SELECT COUNT(*) AS aggregate,
s_id
FROM shipmentMerged_final
WHERE o_company_id = 2449226
  AND o_created_at BETWEEN TIMESTAMP '2025-10-10 00:00:00' AND TIMESTAMP '2025-10-26 23:59:59'
  AND o_shipping_method IN ('SR', 'SRE', 'AC')
  AND o_is_return = 0
  AND o_state = 0
group by 2
limit 1500

Above Query is showing: 1150 total records But When running:

SELECT COUNT(*) AS aggregate
FROM shipmentMerged_final
WHERE o_company_id = 2449226
  AND o_created_at BETWEEN TIMESTAMP '2025-10-10 00:00:00' AND TIMESTAMP '2025-10-26 23:59:59'
  AND o_shipping_method IN ('SR', 'SRE', 'AC')
  AND o_is_return = 0
  AND o_state = 0

The count is coming as: 1162

I'm not sure this is an issue or bug, you're probably running into group trimming - https://docs.pinot.apache.org/users/user-guide-query/query-syntax/grouping-algorithm.