Just curious, how is pinot setting up the limit for num of groups to return for aggregation query? I always get 500,000 rows at most.

Can you paste a query - or just dm and we can test it?