pentaho与hive连接的数据集成

nhaq1z21 于 2021-05-30 发布在 Hadoop

关注(0)|答案(2)|浏览(434)

我正在使用pentaho数据集成，我正在尝试连接到hive，但当我尝试这样做时，我得到以下错误。。。。。

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)
org.apache.thrift.transport.TTransportException

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    
    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.DatabaseMeta.testConnection(DatabaseMeta.java:2685)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.test(DatabaseDialog.java:109)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2.test(CreateDatabaseWizardPage2.java:157)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizardPage2$3.widgetSelected(CreateDatabaseWizardPage2.java:147)
    at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
    at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
    at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
    at org.eclipse.jface.window.Window.open(Window.java:796)
    at org.pentaho.di.ui.core.database.wizard.CreateDatabaseWizard.createAndRunDatabaseWizard(CreateDatabaseWizard.java:111)

使用设置为localhost，端口为8888，数据库为默认值。。。。
请帮忙，等待您的答复。。。。
你好，吉滕·潘萨拉

hadoop Hive data-integration pentaho

来源：https://stackoverflow.com/questions/25625088/pentaho-data-integration-with-hive-connection

2条答案

按热度按时间

tjvv9vkg1#

您使用的是什么hadoop发行版？如果您不使用apache hadoop 0.20.x，则必须通过设置某些属性来配置pdi，有关如何为特定hadoop发行版设置pentaho的更多详细信息，请参阅以下wiki页面：
http://wiki.pentaho.com/display/bad/configuring+pentaho+for+your+hadoop+distro+and+version

赞(0）回复(0）举报 2021-05-30

wwtsj6pe2#

你编辑了plugin文件夹中的plugin.properties吗？？
数据集成>插件>pentaho大数据插件>plugin.properties
将属性“active.hadoop.configuration”更改为您正在使用的hadoop发行版，例如：
active.hadoop.configuration=hdp20
这也许能解决问题。

赞(0）回复(0）举报 2021-05-30

我来回答

pentaho与hive连接的数据集成

2条答案

相关问题

热门标签

最新问答