适用模块/版本

指标平台

具体说明

背景：中交信捷指标平台--指标定义-指标详情一直转圈加载不出来内容

工单：Ticket-35798: 【中交信捷】指标平台--指标定义-指标详情一直转圈加载不出来内容 https://overmind-project.netease.com/v2/my_workbench/ticketdetail/Ticket-35798

排查发现da模块日志报错无法识别多台主机名，日志内搜索关键词：UnknownHostException

2025-02-12 13:42:38.941 ERROR [io-8080-exec-16] org.apache.hive.jdbc.Utils                    : Unable to read HiveServer2 configs from ZooKeeper
2025-02-12 13:42:38.946 WARN  [io-8080-exec-16] c.n.y.da.web.controller.DataSourceController  : f677d360c77e62ca585e96 - vuGezaH0 - [TEST] Failed. nocache <#e2fa1551> java.lang.RuntimeException: java.sql.SQLException: Could not open client transport for any of the Server URI's in ZooKeeper: java.net.UnknownHostException: dn43.cttic.cn
        at c.n.y.d.d.HiveDaoImpl.lambda$test$0(HiveDaoImpl.java:89)
        at c.n.y.d.d.HiveDaoImpl.lambda$exec$10(HiveDaoImpl.java:550)
        at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1742)
        at c.n.y.d.d.HiveDaoImpl.exec(HiveDaoImpl.java:550)
        at c.n.y.d.d.HiveDaoImpl.test(HiveDaoImpl.java:85)
Caused by: <#9c2e7dd3> java.sql.SQLException: Could not open client transport for any of the Server URI's in ZooKeeper: java.net.UnknownHostException: dn43.cttic.cn
        at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:210)
        at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)
        at c.n.y.d.ContextHandler.getConnection(ContextHandler.java:62)
        at c.n.y.d.w.a.t.TimerAspect.doAround(TimerAspect.java:36)
        at c.n.y.d.BaseConn.getDirectConnection(BaseConn.java:98)
Caused by: <#19befebc> org.apache.thrift.transport.TTransportException: java.net.UnknownHostException: dn43.cttic.cn
        at org.apache.thrift.transport.TSocket.open(TSocket.java:226)
        at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:266)
        at org.apache.thrift.transport.TSaslClientTransport.open(TSaslClientTransport.java:37)
        at org.apache.hadoop.hive.thrift.client.TUGIAssumingTransport$1.run(TUGIAssumingTransport.java:52)
        at org.apache.hadoop.hive.thrift.client.TUGIAssumingTransport$1.run(TUGIAssumingTransport.java:49)
Caused by: <#9b0b65f9> java.net.UnknownHostException: dn43.cttic.cn
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:184)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
        at java.net.Socket.connect(Socket.java:589)
        at org.apache.thrift.transport.TSocket.open(TSocket.java:221)
        at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:266)
 impala [jdbc:hive2://nn49.cttic.cn:2182,nn47.cttic.cn:2182,nn48.cttic.cn:2182/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=impala-ha/hiveserver2;principal=impala/_HOST@BDMS.COM] [connect:f,13:31:58.374,640567ms] [link:10m40.605s] [connId:455ed4c2f10de556c9d21b63319217be connSqlId:7fbd842d2e19dc30638df4965b5e26d5]

使用示例

指标平台的DC/DA/DE模块需要重新配置host，easyops搜索配置项：docker_cmd 配置内容需包括：zk节点+hive节点+impala节点

如下图