Querying Pinot data in Trino

[raj1kshtz]

I have recently started working with trino and s3 bucket which worked fine.

Now, my purpose is to query pinot data using trino for which I am facing following issue, need some input in the same.

ISSUE

DESCRIBE, SHOW, USE query is working fine. But whenever I run SELECT query for example SELECT * from table_name it fails with errors like Error received is: Query 20231123_112801_00010_8pc7r failed: Server refused connection:

Now, I am running pinot locally by downloading the binary from (v1.0.0)
https://pinot.apache.org/download/

And following are the commands that I use to run pinot locally (https://docs.pinot.apache.org/basics/getting-started/running-pinot-locally). And before running the pinot locally I have added following 2 lines in pinot-broker.conf file

broker.host=<my-system-ip> broker.http.port=8099

1 ./bin/pinot-admin.sh StartZookeeper -zkPort 2191
2 export JAVA_OPTS="-Xms4G -Xmx8G -XX:+UseG1GC -XX:MaxGCPauseMillis=200 -Xloggc:gc-pinot-controller.log"
./bin/pinot-admin.sh StartController
-zkAddress localhost:2191
-controllerPort 9000
3 export JAVA_OPTS="-Xms4G -Xmx4G -XX:+UseG1GC -XX:MaxGCPauseMillis=200 -Xloggc:gc-pinot-broker.log"
./bin/pinot-admin.sh StartBroker
-zkAddress localhost:2191
4 export JAVA_OPTS="-Xms4G -Xmx16G -XX:+UseG1GC -XX:MaxGCPauseMillis=200 -Xloggc:gc-pinot-server.log"
./bin/pinot-admin.sh StartServer
-zkAddress localhost:2191

The ports for pinot-controller is 9000, pinot-broker is 8099, and pinot-server is 8098. All of which can be seen on the UI, which is accessible with localhost:9000 (When we see in the pinot UI, it says the host is my system IPv4 address).

Now I am running trino in my local machine using following docker-compose file

`
version: '3.8'
services:
trino:
hostname: trino
platform: linux/amd64
image: 'trinodb/trino:351'
ports:
- '8085:8080'
volumes:
- ./etc:/usr/lib/trino/etc:ro
networks:
- trino-network

networks:
trino-network:
driver: bridge
`

node.properties

node.environment=docker node.data-dir=/data/trino plugin.dir=/usr/lib/trino/plugin

config.properties

#single node install config coordinator=true node-scheduler.include-coordinator=true http-server.http.port=8080 discovery-server.enabled=true discovery.uri=http://localhost:8080

pinot.properties

connector.name=pinot pinot.controller-urls=host.docker.internal:9000

using the above configuration I am running trino in my local docker container.

Can anyone please provide me any insight on the same? On how to proceed further so that I can be able to run Select query as well.