Following the Startree documentation you will be prompted to use such config
## Replace the pug.prod.awesome-company.startree.cloud with the link to your pinot cluster
## For the clusters without TLS enabled, the port number will be 80
pinot.controller-urls=proxy.broker.pug.prod.awesome-company.startree.cloud:443
## Enable Pinot Rest Proxy
pinot.proxy-enabled=true
## Replace the pug.prod.awesome-company.startree.cloud with the link to your pinot cluster
pinot.grpc-host=proxy-grpc.broker.pug.prod.awesome-company.startree.cloud
## For the clusters without TLS enabled, the port number will be 80
pinot.grpc-port=443
which is not a working example and the problem is by the date of writing proxy-grpc.broker is nonfunctional and will return 404
io.grpc.StatusRuntimeException: UNIMPLEMENTED: HTTP status code 404 invalid content-type: text/plain; charset=utf-8 headers: Metadata(:status=404,content-type=text/plain; charset=utf-8,x-content-type-options=nosniff,content-length=19,date=Fri, 27 Dec 2024 13:24:23 GMT) DATA----------------------------- 404 page not found at io.grpc.Status.asRuntimeException(Status.java:535) at io.grpc.stub.ClientCalls$BlockingResponseStream.hasNext(ClientCalls.java:648) at com.facebook.presto.pinot.PinotSegmentPageSource.getNextPage(PinotSegmentPageSource.java:205) at com.facebook.presto.operator.ScanFilterAndProjectOperator.processPageSource(ScanFilterAndProjectOperator.java:295) at com.facebook.presto.operator.ScanFilterAndProjectOperator.getOutput(ScanFilterAndProjectOperator.java:260) at com.facebook.presto.operator.Driver.processInternal(Driver.java:441) at com.facebook.presto.operator.Driver.lambda$processFor$10(Driver.java:324) at com.facebook.presto.operator.Driver.tryWithLock(Driver.java:750) at com.facebook.presto.operator.Driver.processFor(Driver.java:317) at com.facebook.presto.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:1079) at com.facebook.presto.execution.executor.PrioritizedSplitRunner.process(PrioritizedSplitRunner.java:165) at com.facebook.presto.execution.executor.TaskExecutor$TaskRunner.run(TaskExecutor.java:621) at com.facebook.presto.$gen.Presto_0_288_SNAPSHOT_aeaa0b7____20241227_132310_1.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:750)
what you need to do is remove the .broker. from the connection string so it looks like this
pinot.grpc-host=proxy-grpc.pug.prod.awesome-company.startree.cloud
and boom you have a working connection from presto to startree pinot