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

Reply via email to