今天在完成Hive的安装配置后,通过java客户端连接Hive进行操作时抛了一个异常:
Exception in thread "main" java.sql.SQLException: Could not establish connection to hadoop0:10000/default: java.net.ConnectException: Connection refused: connect
at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:116)
at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:207)
at hive.HiveConn.main(HiveConn.java:12)
弄了半天原来是未启动hive的服务!于是乎执行命令
hive --service hiveserver &
启动服务!ok搞定!
注:通过java远程访问hive时需要在linux下启动服务;执行命令:
hive --service hiveserver &
(执行完该命令后服务会启动,光标会一直处于闪烁状态,可以回车返回linux命令行)