https://pinot.apache.org/ logo
h

Hakob Avjyan

04/16/2021, 5:40 PM
Hello everyone ! Existed to be part of this slack channel. I am slowly learning Apache Pinot and Superset. Dose anyone know how to expedite the following error
Apache Pino Error
{'errorCode': 410, 'message': 'BrokerResourceMissingError'}
This may be triggered by:
Issue 1002 - The database returned an unexpected error
This is what I got from superset documentation Your query failed because of an error that occurred on the database. This may be due to a syntax error, a bug in your query, or some other internal failure within the database. This is usually not an issue within Superset, but instead a problem with the underlying database that serves your query. What's the best fix for this?
m

Mayank

04/16/2021, 6:17 PM
The error in Pinot means that it did not find the table. Can you try your query directly on Pinot's query console?
1
h

Hakob Avjyan

04/16/2021, 6:29 PM
The data that I am trying to query dose not show up in tables .When I run the select commend in SQL editor I get the same BrokerResourceMissingError .
m

Mayank

04/16/2021, 6:30 PM
There are two possibilities, you there's a typo in the table name in your sql query, or the table is not setup in Pinot correctly
1
h

Hakob Avjyan

04/16/2021, 6:47 PM
Checked for typos everything looks good. The data is being pulled by a bootstrap script from github.
m

Mayank

04/16/2021, 6:47 PM
What table name do you see in the query console, and what happens when you click on that?
You should see something like this in the query console:
h

Hakob Avjyan

04/16/2021, 6:50 PM
I have the same
m

Mayank

04/16/2021, 6:50 PM
And you are querying
baseballStats
table and you get BrokerResourceMissing? That does not make sense. Just clicking the table name would fire a query and show you results.
h

Hakob Avjyan

04/16/2021, 6:55 PM
no the table that I am trying to Query is not showing in Pinot. I guess there is a problem with the Pinot ingestion job. It was suppose to downlead the raw data from the FTP server.
m

Mayank

04/16/2021, 6:56 PM
Yeah so if you don't see the table in query conole, then it does not exist in Pinot, and that would explain the error you are seeing.
1
h

Hakob Avjyan

04/16/2021, 7:00 PM
so there is a bug somewhere in the ingestion script I am assuming
m

Mayank

04/16/2021, 7:00 PM
Not necessarily.
Will need more info on what exactly are you runnign and how
h

Hakob Avjyan

04/16/2021, 7:05 PM
I am have followed the step from this repo https://github.com/kbastani/climate-change-analysis and successfully got Pinot and Superset working on my localhost. Except I was never able to see the data in the Pinot witch resulted the error in Superset.
m

Mayank

04/16/2021, 7:06 PM
Hmm, this is not from official Pinot repo. @Kenny Bastani seems like you built this. Could you please take a look?