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?

The error in Pinot means that it did not find the table. Can you try your query directly on Pinot's query console?

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 .

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

Checked for typos everything looks good. The data is being pulled by a bootstrap script from github.

What table name do you see in the query console, and what happens when you click on that?

I have the same

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.

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.

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.

so there is a bug somewhere in the ingestion script I am assuming

Not necessarily.

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.

Hmm, this is not from official Pinot repo. @Kenny Bastani seems like you built this. Could you please take a look?