Apache Pinot

Hello, I am getting error, can someone tell why is it coming?
```trino error: Failed communicating with server: <https://pinot-cluster-broker-1.pinot-cluster-broker-headless.pinot-cluster.svc.cluster.local:8099/debug/routingTable/>```

Are Pinot and Trino deployed in the same vpc? If not the server addresses may not visible to trino

They are deployed in an eks cluster and it has one vpc assigned to an entire cluster

I think your trino pod doesn’t recongnize the pinot k8s dns

you need to go with pinot proxy or deploy trino and pinot within same k8s

As you can see in the error logs that they are communicating using https if we want to redirect towards http then? <@UGRJA9TEH>

Hey <@UGRJA9TEH> and <@UDQU92KBK>, I am hitting the same problem as above when attempting to connect Trino to Pinot in showcase. What do you mean by using Pinot proxy here?

Are Pinot and trino deployed in different k8s for you?

Yes, but please note this is StarTree deployment in showcase (DEV cluster)

<@UDQU92KBK> I am also not able to get local trino to talk to local pinot docker. When I run:
`select * from pinot.default.airlineStats limit 10;`

I get the following `java.net.ConnectException: Operation timed out`.
```Query 20231111_001302_00007_kukfr failed: Server refused connection: <http://172.17.0.3:8000/query/sql>
java.io.UncheckedIOException: Server refused connection: <http://172.17.0.3:8000/query/sql>```
Here is my simple pinot.properties values:
```connector.name=pinot
pinot.controller-urls=localhost:9000```
Is there any way to unblock local setup?

Not sure why it is attempting to connect to
```172.17.0.3:8000```
Does it make a difference if I attempted connecting local trino to <https://docs.pinot.apache.org/basics/getting-started/running-pinot-locally|local pinot> (w/o docker setup)? It looks like I can control the broker/controller/server endpoints and ports

Is `172.17.0.3`  local host? And is the broker running at
```<http://172.17.0.3:8000/query/sql>```
And what do you see in external view in terms of server/broker names (do they appear as ip addresses or instance names)?