Hello everyone. I’m encountering an error while ru...
# troubleshooting
a
Hello everyone. I’m encountering an error while running an SQL query after enabling the 'Multi-Stage Engine' in the SQL editor. It’s unable to locate the table, which is of hybrid type. Error Code: 720 QueryPlanningError: Error composing query plan for: SELECT * FROM auw_subscriptions LIMIT 1 org.apache.pinot.query.QueryEnvironment.planQuery(QueryEnvironment.java:190) org.apache.pinot.broker.requesthandler.MultiStageBrokerRequestHandler.handleRequest(MultiStageBrokerRequestHandler.java:177) org.apache.pinot.broker.requesthandler.BaseBrokerRequestHandler.handleRequest(BaseBrokerRequestHandler.java:168) org.apache.pinot.broker.requesthandler.BrokerRequestHandlerDelegate.handleRequest(BrokerRequestHandlerDelegate.java:116) Table does not exist: 'auw_subscriptions' org.apache.pinot.shaded.com.google.common.base.Preconditions.checkArgument(Preconditions.java:143) org.apache.pinot.query.catalog.PinotCatalog.getTable(PinotCatalog.java:71) org.apache.calcite.jdbc.SimpleCalciteSchema.getImplicitTable(SimpleCalciteSchema.java:128) org.apache.calcite.jdbc.CalciteSchema.getTable(CalciteSchema.java:283) the table do exists, and I am able to query it if I disable the "Multi-Stage Engine". I got this error first when I tried to do self join on this table, later on I found out that "Multi-Stage engine" is not working properly. Got any tips for troubleshooting this? I'd really appreciate the help!
x
can you paste the snapshot from the query ui
if you are using jdbc client, are you using multiple tenants?
try something like
default.auw_subscriptons
as your table name in the query?
a
Screenshot from 2025-04-29 15-41-32.png
I am using default tenants only
I tried querying using default.auw_subscriptions as table name. Still getting same error.
x
interesting, can you go to cluster view and see if brokers and servers are running ?
a
yes they are running.
x
Can you go to zookeeper viewer and check
BrokerResource
and table in both the IdealState and ExternalView
a
I checked the zookeeper viewer and the name of table is same in both IdealState and ExternalView. All the tables are in online state. I have created transcript table which is provided at pinot-tutorial github page. I tried to query with "Multi-Stage engine" ON, it is throwing same error, "couldn't find transcript table". So, there is no issue with the data that is being loaded.
x
Where is your deployment? Can you also try to restart all components?
Hmm, what about the brokerResources in both IdealStates and ExternalView