jadami10 opened a new issue, #15932: URL: https://github.com/apache/pinot/issues/15932
We have a tenant with multiple tables, N servers for REALTIME tables, and M servers for OFFLINE tables. We use multistage engine queries to join across these tables. One of these tables is a DIM table, but it is correctly replica on all realtime and offline servers. In response to an incident, we updated all queries to query only `_OFFLINE` tables as there were ongoing issues with the realtime servers. But we found queries continued to get routed to realtime servers. This seems to be happening because the join to the DIM table which is replicated on all servers. Given that DIM tables are always expected to be on all servers, they should not be included in determining route-able servers (unless they are the only table being queried). -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org