John Peter S
09/06/2022, 3:52 PMconnector.name=pinot
pinot.controller-urls=localhost:9000
Then I connected to the presto server through the presto cli. I am able to hit show tables
and describe tables
but when I try to get the data out like select count(*) from table
it is timing out with the following error in the presto server
2022-09-06T21:16:18.552+0530 ERROR remote-task-callback-6 com.facebook.presto.execution.StageExecutionStateMachine Stage execution 20220906_154613_00010_877h3.1.0 failed
java.io.UncheckedIOException: java.net.SocketTimeoutException: Connect Timeout
at com.facebook.airlift.http.client.ResponseHandlerUtils.propagate(ResponseHandlerUtils.java:21)
at com.facebook.airlift.http.client.StringResponseHandler.handleException(StringResponseHandler.java:51)
at com.facebook.airlift.http.client.StringResponseHandler.handleException(StringResponseHandler.java:34)
at com.facebook.airlift.http.client.jetty.JettyHttpClient.execute(JettyHttpClient.java:512)
at com.facebook.presto.pinot.PinotClusterInfoFetcher.doHttpActionWithHeaders(PinotClusterInfoFetcher.java:146)
at com.facebook.presto.pinot.PinotBrokerPageSource.lambda$issuePqlAndPopulate$0(PinotBrokerPageSource.java:267)
at com.facebook.presto.pinot.PinotUtils.doWithRetries(PinotUtils.java:40)
at com.facebook.presto.pinot.PinotBrokerPageSource.issuePqlAndPopulate(PinotBrokerPageSource.java:253)
at com.facebook.presto.pinot.PinotBrokerPageSource.getNextPage(PinotBrokerPageSource.java:227)
at com.facebook.presto.operator.TableScanOperator.getOutput(TableScanOperator.java:251)
at com.facebook.presto.operator.Driver.processInternal(Driver.java:381)
at com.facebook.presto.operator.Driver.lambda$processFor$8(Driver.java:283)
at com.facebook.presto.operator.Driver.tryWithLock(Driver.java:677)
at com.facebook.presto.operator.Driver.processFor(Driver.java:276)
at com.facebook.presto.execution.SqlTaskExecution$DriverSplitRunner.processFor(SqlTaskExecution.java:1077)
at com.facebook.presto.execution.executor.PrioritizedSplitRunner.process(PrioritizedSplitRunner.java:162)
at com.facebook.presto.execution.executor.TaskExecutor$TaskRunner.run(TaskExecutor.java:545)
at com.facebook.presto.$gen.Presto_0_234_1f00527____20220906_154419_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:748)
Caused by: java.net.SocketTimeoutException: Connect Timeout
at org.eclipse.jetty.io.ManagedSelector$Connect.run(ManagedSelector.java:768)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
... 3 more
Mayank
Xiang Fu
Xiang Fu
John Peter S
09/07/2022, 4:56 AMJohn Peter S
09/07/2022, 5:48 AMJohn Peter S
09/07/2022, 5:54 AMJohn Peter S
09/07/2022, 6:52 AMXiang Fu
Xiang Fu
John Peter S
09/07/2022, 5:08 PMshow tables
and describe
queries executed properly? Through the controller URL provided in the presto catalog?Xiang Fu
Xiang Fu