本文介绍了如何使用Kettle连接到Hive和Hive2，包括启动Hiveserver和配置Kettle连接。同时，文章详细解析了连接Hive2时遇到的错误及解决方案，如修改Kettle的plugin.properties文件和添加必要的JAR包。最后，提到了使用Hive2的优点，如优化连接和增强安全性。
展开全部
连接hive的方法：
进入hive所在的服务器，输入：hive --service hiveserver(目的：启32313133353236313431303231363533e58685e5aeb931333363363430动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.Databas
最低0.47元/天 解锁文章
6378
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
