dang-stripe opened a new issue, #17625: URL: https://github.com/apache/pinot/issues/17625
Got the following query failure when doing a lookup join on an empty dim table: Query ``` SELECT /*+ joinOptions(join_strategy='lookup') */ FROM table1 JOIN table2 ON table1.key = table2.key LIMIT 5 ``` Logs ``` WARN [MultiStageBrokerRequestHandler] [jersey-server-managed-async-executor-112:687] Request 1234 failed with exception [2026-02-03 22:36:09.020228] org.apache.pinot.spi.exception.QueryException: Error while planning query ... [2026-02-03 22:36:09.020930] Caused by: java.lang.RuntimeException: Error composing query plan for 'SELECT /*+ joinOptions(join_strategy='lookup') */ FROM table1 JOIN table2 ON table1.key = table2.key LIMIT 5': bound must be positive' [2026-02-03 22:36:09.020951] at org.apache.pinot.query.QueryEnvironment$CompiledQuery.planQuery(QueryEnvironment.java:967) [2026-02-03 22:36:09.020967] at org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.lambda$query$5(MultiStageBrokerRequestHandler.java:546) [2026-02-03 22:36:09.020980] at org.apache.pinot.spi.query.QueryThreadContext$1.lambda$decorate$0(QueryThreadContext.java:190) [2026-02-03 22:36:09.020985] ... 4 more [2026-02-03 22:36:09.020996] Caused by: java.lang.IllegalArgumentException: bound must be positive [2026-02-03 22:36:09.021005] at java.base/java.util.Random.nextInt(Random.java:557) [2026-02-03 22:36:09.021017] at org.apache.pinot.query.routing.WorkerManager.assignWorkersToIntermediateFragment(WorkerManager.java:241) [2026-02-03 22:36:09.021034] at org.apache.pinot.query.routing.WorkerManager.assignWorkersToNonRootFragment(WorkerManager.java:147) [2026-02-03 22:36:09.021046] at org.apache.pinot.query.routing.WorkerManager.assignWorkers(WorkerManager.java:114) [2026-02-03 22:36:09.021060] at org.apache.pinot.query.planner.physical.PinotDispatchPlanner.createDispatchableSubPlan(PinotDispatchPlanner.java:70) [2026-02-03 22:36:09.021072] at org.apache.pinot.query.QueryEnvironment.toDispatchableSubPlan(QueryEnvironment.java:519) [2026-02-03 22:36:09.021083] at org.apache.pinot.query.QueryEnvironment.toDispatchableSubPlan(QueryEnvironment.java:501) [2026-02-03 22:36:09.021095] at org.apache.pinot.query.QueryEnvironment$CompiledQuery.planQuery(QueryEnvironment.java:962) ``` Which points to https://github.com/apache/pinot/blob/441d335dcf04647c34353aec9213c8361f4009a0/pinot-query-planner/src/main/java/org/apache/pinot/query/routing/WorkerManager.java#L241 -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
