Hi team , I am facing issues when trying to enable...
# troubleshooting
r
Hi team , I am facing issues when trying to enable multistage engine in pinot UI , and the error message is not very clear attaching snippet , looking forward to get help to diagnose the issue . It says table does not exist but it does.
m
Your screenshot does not include the query, if you can share it in text form. Also adding @Gonzalo Ortiz to take a look.
g
My two cents: remember that MSE is case-dependent, may that be the reason?
r
Query - SELECT b., i. FROM bat b LEFT JOIN intent i ON b.requestId = i.requestId WHERE b.eventTimestamp BETWEEN 1749559453000 AND 1749559480000 AND i.intentId = 'au_digital_buyer_fraud_check' ORDER BY b.eventTimestamp DESC LIMIT 10000
@Gonzalo Ortiz can you pls elaborate or pin point the issue with my query , i have kept lowercase while referring to my table and it matches my table name .
y
Does a simple
SELECT * FROM bat LIMIT 10
query also fail similarly with the multi-stage engine?
r
yes.
But it does give results if MSE is unchecked.
y
Are these tables all in the default database or are you using different database names - https://docs.pinot.apache.org/configuration-reference/database?
r
default database.
g
strange... which version are you using?
r
how do we check that ?
m
You probably know what verion you deployed, right? Alternatively, you can check the
/version
api in Swagger
g
also, do you have the same problem with other tables or only with bat?
r
same issue with all tables .
g
Can you try adding _OFFLINE or _REALTIME as a suffix for the table? ie
bar_OFFLINE
r
these are realtime data getting stored.
g
Can you add then the _REALTIME suffix?
If it works with _REALTIME but not without it, it is definitely a bug.