错误代码PINOT_UNABLE_TO_FIND_BROKER :找不到有效的代理

Question

我正在尝试使用presto查询pinot表数据，下面是我的配置详细信息。

started Pinot is one of the sit server.i.e. 10.184.160.52
Controller: 10.184.160.52:9000
server: 10.184.160.52:7000
broker: 10.184.160.52:8000

我有Presto在不同的服务器端口是开放的b/w这两个服务器。i.e.10.184.160.53

Created One pinot.properties file inside presto/etc/catalog/pinot.properties.

connector.name=pinot
pinot.controller-urls=Controller_Host:9000

bin/launcher run ---> Loaded Pinot catalog.
Started Prestro with Pinot Segment.

./presto --server 10.184.160.53:8080 --catalog pinot


show catalogs;(able to see my Catalog)
pinot

show schemas;  (able to see sachema also)
presto> show schemas;
   Schema       
--------------------
default 


presto> use default;
USE
presto:default> show tables;----(able to see pinot tables:)
    Table             
------------------------------
test                
test2 
test3                       
(3 rows)

Query 20210519_124218_00061_vcz4u, FINISHED, 1 node
Splits: 19 total, 19 done (100.00%)
0:00 [3 rows, 98B] [10 rows/s, 340B/s]

但是当我执行select * from test时，它显示没有找到代理

presto:default> select * from test;
Query 20210519_124230_00062_vcz4u failed: No valid brokers found for test

完整的Presto日志：

Error Code  PINOT_UNABLE_TO_FIND_BROKER (84213767)
Stack Trace
io.prestosql.pinot.PinotException: No valid brokers found for test
at io.prestosql.pinot.client.PinotClient.getBrokerHost(PinotClient.java:285)
at io.prestosql.pinot.client.PinotClient.sendHttpGetToBrokerJson(PinotClient.java:185)
at io.prestosql.pinot.client.PinotClient.getRoutingTableForTable(PinotClient.java:302)
at io.prestosql.pinot.PinotSplitManager.generateSplitsForSegmentBasedScan(PinotSplitManager.java:72)
at io.prestosql.pinot.PinotSplitManager.getSplits(PinotSplitManager.java:167)
at io.prestosql.split.SplitManager.getSplits(SplitManager.java:87)
at io.prestosql.sql.planner.DistributedExecutionPlanner$Visitor.visitScanAndFilter(DistributedExecutionPlanner.java:203)
at io.prestosql.sql.planner.DistributedExecutionPlanner$Visitor.visitTableScan(DistributedExecutionPlanner.java:185)
at io.prestosql.sql.planner.DistributedExecutionPlanner$Visitor.visitTableScan(DistributedExecutionPlanner.java:156)
at io.prestosql.sql.planner.plan.TableScanNode.accept(TableScanNode.java:143)
at io.prestosql.sql.planner.DistributedExecutionPlanner.doPlan(DistributedExecutionPlanner.java:124)
at io.prestosql.sql.planner.DistributedExecutionPlanner.doPlan(DistributedExecutionPlanner.java:131)
at io.prestosql.sql.planner.DistributedExecutionPlanner.plan(DistributedExecutionPlanner.java:101)
at io.prestosql.execution.SqlQueryExecution.planDistribution(SqlQueryExecution.java:470)
at io.prestosql.execution.SqlQueryExecution.start(SqlQueryExecution.java:386)
at io.prestosql.execution.SqlQueryManager.createQuery(SqlQueryManager.java:237)
at io.prestosql.dispatcher.LocalDispatchQuery.lambda$startExecution$7(LocalDispatchQuery.java:143)
at io.prestosql.$gen.Presto_350____20210519_105836_2.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)

我不能理解这里发生了什么，为什么这个问题显示为像pinot broker这样的精选statement.Looks不接受queries.someOne，请建议，这里是什么问题。

Answer 1

更新:这是因为连接器不支持大小写混合的表名。支持大小写混合的列名。有一个拉取请求，要求添加对混合大小写表名的支持：https://github.com/trinodb/trino/pull/7630