Could not open client transport with JDBC Uri hive jdbc connection refused_java.sql.sqlexception: could not open client trans

2020/03/23 15:08:42-[INFO]-[org.apache.hive.jdbc.Utils.parseURL(Utils.java:285)]-Supplied authorities: 172.18.6.1:10000
2020/03/23 15:08:42-[INFO]-[org.apache.hive.jdbc.Utils.parseURL(Utils.java:372)]-Resolved authority: 172.18.6.1:10000
2020/03/23 15:08:42-[INFO]-[org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:189)]-Will try to open client transport with JDBC Uri: jdbc:hive2://172.18.6.1:10000/ekwing_dataware
2020/03/23 15:08:48-[INFO]-[org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:194)]-Could not open client transport with JDBC Uri: jdbc:hive2://172.18.6.1:10000/ekwing_dataware
2020/03/23 15:08:48-[ERROR]-[com.ekwing.dbOpreation.SaveDataNoRedundancy.init(SaveDataNoRedundancy.java:68)]-Could not open client transport with JDBC Uri: jdbc:hive2://172.18.6.1:10000/ekwing_dataware: java.net.ConnectException: Connection refused: connect
java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://172.18.6.1:10000/ekwing_dataware: java.net.ConnectException: Connection refused: connect
	at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:215)
	at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:163)
	at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
	at java.sql.DriverManager.getConnection(DriverManager.java:664)
	at java.sql.DriverManager.getConnection(DriverManager.java:247)
	at com.ekwing.dbOpreation.SaveDataNoRedundancy.init(SaveDataNoRedundancy.java:58)
	at com.ekwing.dbOpreation.start.main(start.java:15)
Caused by: org.apache.thrift.transport.TTransportException: java.net.ConnectException: Connection refused: connect
	at org.apache.thrift.transport.TSocket.open(TSocket.java:187)
	at org.apache.thrift.transport.TSaslTransport.open(TSaslTransport.java:266)
	at org.apache.thrift.transport.TSaslClientTransport.open(TSaslClientTransport.java:37)
	at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:190)
	... 6 more
Caused by: java.net.ConnectException: Connection refused: connect
	at java.net.DualStackPlainSocketImpl.connect0(Native Method)
	at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
	at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
	at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
	at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
	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:182)
	... 9 more

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

呵呵，因为我的hiveserver2不在这个节点上，我把ip写错了而已，如果你的在这个节点上，那就检查hiveserver2是否启动 netstat -anp |grep 10000 ，如果执行了没有任何反应 就是没启动，启动一下就行