如何使用kettle连接hive和hive2

最新推荐文章于 2024-05-11 09:57:43 发布

jsjw18

最新推荐文章于 2024-05-11 09:57:43 发布

阅读量2.1w

点赞数

分类专栏： kettle 文章标签： thrift etl kettle hive

本文链接：https://blog.csdn.net/victor_ww/article/details/40041589

版权

连接hive的方法：

进入hive所在的服务器，输入：hive --service hiveserver（目的：启动thrift）
打开kettle配置连接界面，输入hive所在服务器的ip、所需要的hive库、端口号（thrift默认端口为：10000）
测试连接，即可

连接hive2的方法：

Error connecting to database [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)
Unable to load Hive Server 2 JDBC driver for the currently active Hadoop configuration


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)
Unable to load Hive Server 2 JDBC driver for the currently active Hadoop configuration


at org.pentaho.di.core.database.Database.normalConnect(Database.java:428)
at org.pentaho.di.core.database.Database.connect(Database.java:361)
at org.pentaho.di.core.database.Database.connect(Database.java:314)
at org.pentaho.di.core.database.Database.connect(Database.java:302)
at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:80)
at org.pentaho.di.core.database.DatabaseM