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!