Does the multi stage query engine care about tenants when assigning the intermediate servers for performing the join? I have two tables which have different server tenant tags but the same broker tenant.

I’m pretty sure it does, but when @Rong R is back from Vacation, maybe he can help verify. 🙂

Thanks!

if tableA is on tenant1; tableB is on tenant2 and you want to join them. all servers in both tenant1 and tenant2 will be used for intermediate stage

What happens when there are no servers which have both the tenant tags?

“all servers in both tenant1 and tenant2” --> all servers in tenant1 AND all servers in tenant2

Thanks!