kettle连接hive错误

最新推荐文章于 2024-09-12 19:58:41 发布

原创最新推荐文章于 2024-09-12 19:58:41 发布 · 4.2k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#hive

hive 专栏收录该内容

5 篇文章

订阅专栏

本文描述了Hive连接数据库时遇到的错误及解决步骤。通过使用hive--servicehiveserver命令启动服务，成功解决了会话关闭和hiveserver进程退出的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

hive运行报错

错误连接数据库 [hive] : org.pentaho.di.core.exception.KettleDatabaseException: 
Error occured while trying to connect to the database

Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver)
org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset


org.pentaho.di.core.exception.KettleDatabaseException: 
Error occured while trying to connect to the database

Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver)
org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset


	at 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。