Is there any limit in Pinot to execute queries sim...
# general
r
Is there any limit in Pinot to execute queries simentenoulsly. I.e. I have created a pipeline through pinot where we are ingesting data from Kafka topic and creating Pinot table.After that connecting from prestro using pinot-connector and in the last step connecting from superset and from there querying pinot table. Here I have generated 4 graphs using diff SQL queries and added all 4 in one dashboard.After sometime when I am trying refresh the dashboard page so it's firing 4 queries to Pinot and all are getting failed it's showing internal error couldn't reach host, and if I am refreshing one slice from the dashboard then it's working fine.i.e. when firing one query at a time. P.S. I am facing this issue when I have started pinot in cluster mode with 3 servers 2 controller and 2 broker. When I am doing the same using quick-start it's working fine and entire dashboard is loading/refreshing at same time.
This is msg it's showing if I am trying to refresh dashboard some slice of dashboard is working and some are failing then again I need to refresh it one by one then it's loading on dashboard.
@User
m
Does querying Pinot directly work when you get this error via Presto?
Let's first understand if the issue is on Pinot side or Presto side
Also, let's move to troubleshooting
r
Ok @User let me move question to troubleshooting .