https://pinot.apache.org/ logo
#general
Title
# general
s

Sowmiya

01/31/2022, 9:02 AM
Could you please suggest a frontend tool(PowerBI, Snowflake etc) for report generation which supports pinot? with documents pls
k

Kishore G

01/31/2022, 4:23 PM
Most folks use superset. Tableau or PowerBI
s

Srini Kadamati

02/01/2022, 8:07 PM
hey Sowmiya, I’m involved with the Superset project and with Preset.io, who offers a commercial solution for Superset. Pinot x Superset work great together! https://superset.apache.org/docs/databases/pinot Check out this great post by @User https://medium.com/apache-pinot-developer-blog/building-a-climate-dashboard-with-apache-pinot-and-superset-d3ee8cb7941d
s

Sowmiya

02/04/2022, 2:48 PM
Hi @User Link is not working. we are trying to connect pinot and superset. but no luck. we have installed pinot and superset, both are up and running. we dont know what next to be done and what are the files we need to make changes.
s

Srini Kadamati

02/04/2022, 4:16 PM
hi Sowmiya, it’s hard to help without any context, error logs, screenshots, 😞
what issue are you running into? 9 times out of 10, I’ve seen that people run into 1 of the following issues: • Networking: Superset can’t physically connect to Pinot. This is a hard one to give general advice on, b/c people run all types of different networking configurations but I’d recommend the usual steps with your debugging hat on! If you’re using Docker, fire up the shell for the backend container and try connecting directly using the database driver (Superset just wraps / sits on top of the driver anyway). Dive deeper into the error. Use ping / wget / etc to test your networking setup, and iterate. • Database driver not found: The database driver needs to be installed in the same python context that Superset is running in. Sometimes people will add the driver and do docker-compose down then up and Superset still hasn’t found the driver. So doing a
pip freeze | grep 'pinot'
when you’re in the shell environment for the backend (if you’re using docker compose this is called
superset_app
) will confirm if the pinot driver actually got installed or not 😄
let me know what additional context you can provide @User
s

Sowmiya

02/05/2022, 5:35 AM
Hi @User Actually we have few questions, 1. Pinot and superset installed in the cloud. Do we need to install docker for connection between pinot and superset? if so, then we need to install superset within docker? 2. If we dont require docker installation, then what are the files we need to make changes for pinot and superset connection. Sorry for these type of questions. I'm bit confused here
s

Srini Kadamati

02/05/2022, 5:00 PM
By “cloud” — do you mean that you’re self-hosting Superset and Pinot?
Docker works well for containerizing your dependencies and environment but isn’t a necessity to use either Pinot or Superset
but first, are you running Superset “natively” (e.g. by running the python backend server + the node frontend server) or within Docker? Within Kubernetes? How about Pinot?
Superset’s backend is written in Python, so you just need to make sure that the pinot driver (https://pypi.org/project/pinotdb/) is installed in the same python / virtual environment context as Superset is in. Does that make sense? If you see “Pinot” listed in the add database modal in Superset, then Superset can find this driver // installation worked. The next step is to figure out how to connect Pinot to Superset
s

Sowmiya

02/07/2022, 2:22 PM
@User We have linux Virtual machine in AWS, in that we have installed pinot and superset manually. We also installed python. we downloaded python pinotdb as well.
s

Srini Kadamati

02/07/2022, 4:50 PM
how do you start the Superset backend / server? Can you verify that
pinotdb
is available in that Python or virtualenvironment context?