walterddr opened a new issue, #11003: URL: https://github.com/apache/pinot/issues/11003
see follow-up in #10873 we replaced the simple SqlNode-based parsing mechanism to extract all visited tables with Calcite's relational toolset because it handles a much wider range of corner cases. However, this is a problem for pinot-client: pinot-client doesn't have a full picture of all the tables and their associated schema/config info to successfully create a local logical planner. thus it cannot determine the list of tables to look for common broker tenant/host. several redesign thoughts are possible 1. only allow controller-based broker selector in the multi-tenant scenario. otherwise fall back to random tenant/host selection - additionally it also need to build a local table cache within the client - or hit controller endpoint to get query routing info before hitting the broker 2. utilize DML to gather information about table/schema in pinot-client. 3. explicitly ask for broker tenant info in pinot-client -- 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