kettle连接hive错误

来源：互联网发布：格罗玛什地狱咆哮知乎编辑：程序博客网时间：2024/05/17 02:31

hive运行报错

错误连接数据库 [hive] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the databaseError connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver)org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection resetorg.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the databaseError connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver)org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection resetat org.pentaho.di.core.database.Database.normalConnect(Database.java:415)at org.pentaho.di.core.database.Database.connect(Database.java:353)at org.pentaho.di.core.database.Database.connect(Database.java:306)at org.pentaho.di.core.database.Database.connect(Database.java:294)at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:84)at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2459)at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:541)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)at java.lang.reflect.Method.invoke(Method.java:597)at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)

kettle服务稳定运行了一个多月，今天上班时突然，出现上述错误，很明显是hiveserver进程挂了，使用hive --service hiveserver >/dev/null 2>/dev/null &命令启动服务，会话关闭，hiveserver进程退出，使用nohup hive --service hiveserver >/dev/null 2>/dev/null & 放到linux后端执行，问题解决ok。

0 0