org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.hsqldb.jdbcDriver) Unable to load Hive JDBC driver for the currently active Hadoop configuration

Pentaho BI Platform Tracking | Thomas Morgner | 4 years ago
  1. 0

    I try to add a new JDBC connection for a HSQL-DB using the generic driver: Name: Memory URL: jdbc:hsql:mem:SampleData Driver-Class: org.hsqldb.jdbcDriver User: pentaho_user Pass: password When I hit test, I am greeted with this exception: Error connecting to database [Memory] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.hsqldb.jdbcDriver) Unable to load Hive 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.hsqldb.jdbcDriver) Unable to load Hive JDBC driver for the currently active Hadoop configuration at org.pentaho.di.core.database.Database.normalConnect(Database.java:412) at org.pentaho.di.core.database.Database.connect(Database.java:350) at org.pentaho.di.core.database.Database.connect(Database.java:303) at org.pentaho.di.core.database.Database.connect(Database.java:291) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:86) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2382) 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.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:682) at java.awt.EventQueue.access$000(EventQueue.java:85) at java.awt.EventQueue$1.run(EventQueue.java:643) at java.awt.EventQueue$1.run(EventQueue.java:641) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:652) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:205) at java.awt.Dialog$1.run(Dialog.java:1044) at java.awt.Dialog$3.run(Dialog.java:1096) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1094) at java.awt.Component.show(Component.java:1584) at java.awt.Component.setVisible(Component.java:1536) at java.awt.Window.setVisible(Window.java:841) at java.awt.Dialog.setVisible(Dialog.java:984) at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:238) at org.pentaho.reporting.designer.extensions.connectioneditor.XulDatabaseDialog.open(XulDatabaseDialog.java:228) at org.pentaho.reporting.designer.extensions.connectioneditor.ConnectionEditorPanel$AddDataSourceAction.actionPerformed(ConnectionEditorPanel.java:177) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6375) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6140) at java.awt.Container.processEvent(Container.java:2083) at java.awt.Component.dispatchEventImpl(Component.java:4737) at java.awt.Container.dispatchEventImpl(Container.java:2141) at java.awt.Component.dispatchEvent(Component.java:4565) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4619) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4280) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4210) at java.awt.Container.dispatchEventImpl(Container.java:2127) at java.awt.Window.dispatchEventImpl(Window.java:2482) at java.awt.Component.dispatchEvent(Component.java:4565) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:684) at java.awt.EventQueue.access$000(EventQueue.java:85) at java.awt.EventQueue$1.run(EventQueue.java:643) at java.awt.EventQueue$1.run(EventQueue.java:641) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98) at java.awt.EventQueue$2.run(EventQueue.java:657) at java.awt.EventQueue$2.run(EventQueue.java:655) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:654) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:205) at java.awt.Dialog$1.run(Dialog.java:1044) at java.awt.Dialog$3.run(Dialog.java:1096) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1094) at java.awt.Component.show(Component.java:1584) at java.awt.Component.setVisible(Component.java:1536) at java.awt.Window.setVisible(Window.java:841) at java.awt.Dialog.setVisible(Dialog.java:984) at org.pentaho.reporting.libraries.designtime.swing.CommonDialog.setVisible(CommonDialog.java:280) at org.pentaho.reporting.libraries.designtime.swing.CommonDialog.performEdit(CommonDialog.java:193) at org.pentaho.reporting.designer.extensions.connectioneditor.ConnectionEditorDialog.performEditConnections(ConnectionEditorDialog.java:60) at org.pentaho.reporting.designer.extensions.connectioneditor.ConnectionEditorAction.actionPerformed(ConnectionEditorAction.java:45) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.AbstractButton.doClick(AbstractButton.java:389) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809) at com.apple.laf.AquaMenuItemUI.doClick(AquaMenuItemUI.java:137) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850) at java.awt.Component.processMouseEvent(Component.java:6375) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6140) at java.awt.Container.processEvent(Container.java:2083) at java.awt.Component.dispatchEventImpl(Component.java:4737) at java.awt.Container.dispatchEventImpl(Container.java:2141) at java.awt.Component.dispatchEvent(Component.java:4565) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4619) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4280) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4210) at java.awt.Container.dispatchEventImpl(Container.java:2127) at java.awt.Window.dispatchEventImpl(Window.java:2482) at java.awt.Component.dispatchEvent(Component.java:4565) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:684) at java.awt.EventQueue.access$000(EventQueue.java:85) at java.awt.EventQueue$1.run(EventQueue.java:643) at java.awt.EventQueue$1.run(EventQueue.java:641) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98) at java.awt.EventQueue$2.run(EventQueue.java:657) at java.awt.EventQueue$2.run(EventQueue.java:655) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:654) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class org.hsqldb.jdbcDriver) Unable to load Hive JDBC driver for the currently active Hadoop configuration at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:537) at org.pentaho.di.core.database.Database.normalConnect(Database.java:396) ... 120 more Caused by: java.sql.SQLException: Unable to load Hive JDBC driver for the currently active Hadoop configuration at org.apache.hadoop.hive.jdbc.HiveDriver.getActiveDriver(HiveDriver.java:106) at org.apache.hadoop.hive.jdbc.HiveDriver.callWithActiveDriver(HiveDriver.java:120) at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:131) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:521) ... 121 more Caused by: java.lang.Exception: Unable to locate Hadoop Configuration Registry at org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.findHadoopConfigurationProvider(HadoopConfigurationUtil.java:101) at org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.getProvider(HadoopConfigurationUtil.java:107) at org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.getActiveConfiguration(HadoopConfigurationUtil.java:119) at org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.getActiveHadoopShim(HadoopConfigurationUtil.java:130) at org.apache.hadoop.hive.jdbc.HiveDriver.getActiveDriver(HiveDriver.java:101) ... 126 more Caused by: java.lang.Exception: Unable to locate Big Data Plugin at org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.findBigDataPluginClassLoader(HadoopConfigurationUtil.java:85) at org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.findHadoopConfigurationProvider(HadoopConfigurationUtil.java:91) ... 130 more Caused by: java.lang.reflect.InvocationTargetException 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.hadoop.hive.jdbc.HadoopConfigurationUtil.findBigDataPluginClassLoader(HadoopConfigurationUtil.java:83) ... 131 more Caused by: org.pentaho.di.core.exception.KettlePluginException: Not a valid plugin at org.pentaho.di.core.plugins.PluginRegistry.getClassLoader(PluginRegistry.java:821) ... 136 more Hostname : Port : 1521 Database name : Why is it even calling Hadoop and why is it not able to handle a missing *plugin*. The Big-Data plugin should be a optional component, otherwise the term plugin is not correct for it.

    Pentaho BI Platform Tracking | 4 years ago | Thomas Morgner
    org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.hsqldb.jdbcDriver) Unable to load Hive JDBC driver for the currently active Hadoop configuration
  2. 0

    I try to add a new JDBC connection for a HSQL-DB using the generic driver: Name: Memory URL: jdbc:hsql:mem:SampleData Driver-Class: org.hsqldb.jdbcDriver User: pentaho_user Pass: password When I hit test, I am greeted with this exception: Error connecting to database [Memory] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.hsqldb.jdbcDriver) Unable to load Hive 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.hsqldb.jdbcDriver) Unable to load Hive JDBC driver for the currently active Hadoop configuration at org.pentaho.di.core.database.Database.normalConnect(Database.java:412) at org.pentaho.di.core.database.Database.connect(Database.java:350) at org.pentaho.di.core.database.Database.connect(Database.java:303) at org.pentaho.di.core.database.Database.connect(Database.java:291) at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:86) at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2382) 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.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58) at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:682) at java.awt.EventQueue.access$000(EventQueue.java:85) at java.awt.EventQueue$1.run(EventQueue.java:643) at java.awt.EventQueue$1.run(EventQueue.java:641) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:652) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:205) at java.awt.Dialog$1.run(Dialog.java:1044) at java.awt.Dialog$3.run(Dialog.java:1096) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1094) at java.awt.Component.show(Component.java:1584) at java.awt.Component.setVisible(Component.java:1536) at java.awt.Window.setVisible(Window.java:841) at java.awt.Dialog.setVisible(Dialog.java:984) at org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:238) at org.pentaho.reporting.designer.extensions.connectioneditor.XulDatabaseDialog.open(XulDatabaseDialog.java:228) at org.pentaho.reporting.designer.extensions.connectioneditor.ConnectionEditorPanel$AddDataSourceAction.actionPerformed(ConnectionEditorPanel.java:177) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272) at java.awt.Component.processMouseEvent(Component.java:6375) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6140) at java.awt.Container.processEvent(Container.java:2083) at java.awt.Component.dispatchEventImpl(Component.java:4737) at java.awt.Container.dispatchEventImpl(Container.java:2141) at java.awt.Component.dispatchEvent(Component.java:4565) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4619) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4280) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4210) at java.awt.Container.dispatchEventImpl(Container.java:2127) at java.awt.Window.dispatchEventImpl(Window.java:2482) at java.awt.Component.dispatchEvent(Component.java:4565) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:684) at java.awt.EventQueue.access$000(EventQueue.java:85) at java.awt.EventQueue$1.run(EventQueue.java:643) at java.awt.EventQueue$1.run(EventQueue.java:641) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98) at java.awt.EventQueue$2.run(EventQueue.java:657) at java.awt.EventQueue$2.run(EventQueue.java:655) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:654) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:205) at java.awt.Dialog$1.run(Dialog.java:1044) at java.awt.Dialog$3.run(Dialog.java:1096) at java.security.AccessController.doPrivileged(Native Method) at java.awt.Dialog.show(Dialog.java:1094) at java.awt.Component.show(Component.java:1584) at java.awt.Component.setVisible(Component.java:1536) at java.awt.Window.setVisible(Window.java:841) at java.awt.Dialog.setVisible(Dialog.java:984) at org.pentaho.reporting.libraries.designtime.swing.CommonDialog.setVisible(CommonDialog.java:280) at org.pentaho.reporting.libraries.designtime.swing.CommonDialog.performEdit(CommonDialog.java:193) at org.pentaho.reporting.designer.extensions.connectioneditor.ConnectionEditorDialog.performEditConnections(ConnectionEditorDialog.java:60) at org.pentaho.reporting.designer.extensions.connectioneditor.ConnectionEditorAction.actionPerformed(ConnectionEditorAction.java:45) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242) at javax.swing.AbstractButton.doClick(AbstractButton.java:389) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809) at com.apple.laf.AquaMenuItemUI.doClick(AquaMenuItemUI.java:137) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850) at java.awt.Component.processMouseEvent(Component.java:6375) at javax.swing.JComponent.processMouseEvent(JComponent.java:3267) at java.awt.Component.processEvent(Component.java:6140) at java.awt.Container.processEvent(Container.java:2083) at java.awt.Component.dispatchEventImpl(Component.java:4737) at java.awt.Container.dispatchEventImpl(Container.java:2141) at java.awt.Component.dispatchEvent(Component.java:4565) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4619) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4280) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4210) at java.awt.Container.dispatchEventImpl(Container.java:2127) at java.awt.Window.dispatchEventImpl(Window.java:2482) at java.awt.Component.dispatchEvent(Component.java:4565) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:684) at java.awt.EventQueue.access$000(EventQueue.java:85) at java.awt.EventQueue$1.run(EventQueue.java:643) at java.awt.EventQueue$1.run(EventQueue.java:641) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98) at java.awt.EventQueue$2.run(EventQueue.java:657) at java.awt.EventQueue$2.run(EventQueue.java:655) at java.security.AccessController.doPrivileged(Native Method) at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87) at java.awt.EventQueue.dispatchEvent(EventQueue.java:654) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188) at java.awt.EventDispatchThread.run(EventDispatchThread.java:122) Caused by: org.pentaho.di.core.exception.KettleDatabaseException: Error connecting to database: (using class org.hsqldb.jdbcDriver) Unable to load Hive JDBC driver for the currently active Hadoop configuration at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:537) at org.pentaho.di.core.database.Database.normalConnect(Database.java:396) ... 120 more Caused by: java.sql.SQLException: Unable to load Hive JDBC driver for the currently active Hadoop configuration at org.apache.hadoop.hive.jdbc.HiveDriver.getActiveDriver(HiveDriver.java:106) at org.apache.hadoop.hive.jdbc.HiveDriver.callWithActiveDriver(HiveDriver.java:120) at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:131) at java.sql.DriverManager.getConnection(DriverManager.java:582) at java.sql.DriverManager.getConnection(DriverManager.java:185) at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:521) ... 121 more Caused by: java.lang.Exception: Unable to locate Hadoop Configuration Registry at org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.findHadoopConfigurationProvider(HadoopConfigurationUtil.java:101) at org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.getProvider(HadoopConfigurationUtil.java:107) at org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.getActiveConfiguration(HadoopConfigurationUtil.java:119) at org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.getActiveHadoopShim(HadoopConfigurationUtil.java:130) at org.apache.hadoop.hive.jdbc.HiveDriver.getActiveDriver(HiveDriver.java:101) ... 126 more Caused by: java.lang.Exception: Unable to locate Big Data Plugin at org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.findBigDataPluginClassLoader(HadoopConfigurationUtil.java:85) at org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.findHadoopConfigurationProvider(HadoopConfigurationUtil.java:91) ... 130 more Caused by: java.lang.reflect.InvocationTargetException 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.hadoop.hive.jdbc.HadoopConfigurationUtil.findBigDataPluginClassLoader(HadoopConfigurationUtil.java:83) ... 131 more Caused by: org.pentaho.di.core.exception.KettlePluginException: Not a valid plugin at org.pentaho.di.core.plugins.PluginRegistry.getClassLoader(PluginRegistry.java:821) ... 136 more Hostname : Port : 1521 Database name : Why is it even calling Hadoop and why is it not able to handle a missing *plugin*. The Big-Data plugin should be a optional component, otherwise the term plugin is not correct for it.

    Pentaho BI Platform Tracking | 4 years ago | Thomas Morgner
    org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class org.hsqldb.jdbcDriver) Unable to load Hive JDBC driver for the currently active Hadoop configuration

    Root Cause Analysis

    1. org.pentaho.di.core.exception.KettlePluginException

      Not a valid plugin

      at org.pentaho.di.core.plugins.PluginRegistry.getClassLoader()
    2. org.pentaho.di
      PluginRegistry.getClassLoader
      1. org.pentaho.di.core.plugins.PluginRegistry.getClassLoader(PluginRegistry.java:821)
      1 frame
    3. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    4. org.pentaho.hadoop
      HadoopConfigurationUtil.getActiveHadoopShim
      1. org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.findBigDataPluginClassLoader(HadoopConfigurationUtil.java:83)
      2. org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.findHadoopConfigurationProvider(HadoopConfigurationUtil.java:91)
      3. org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.getProvider(HadoopConfigurationUtil.java:107)
      4. org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.getActiveConfiguration(HadoopConfigurationUtil.java:119)
      5. org.pentaho.hadoop.hive.jdbc.HadoopConfigurationUtil.getActiveHadoopShim(HadoopConfigurationUtil.java:130)
      5 frames
    5. org.apache.hadoop
      HiveDriver.connect
      1. org.apache.hadoop.hive.jdbc.HiveDriver.getActiveDriver(HiveDriver.java:101)
      2. org.apache.hadoop.hive.jdbc.HiveDriver.callWithActiveDriver(HiveDriver.java:120)
      3. org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:131)
      3 frames
    6. Java RT
      DriverManager.getConnection
      1. java.sql.DriverManager.getConnection(DriverManager.java:582)
      2. java.sql.DriverManager.getConnection(DriverManager.java:185)
      2 frames
    7. org.pentaho.di
      DatabaseMeta.testConnection
      1. org.pentaho.di.core.database.Database.connectUsingClass(Database.java:521)
      2. org.pentaho.di.core.database.Database.normalConnect(Database.java:396)
      3. org.pentaho.di.core.database.Database.connect(Database.java:350)
      4. org.pentaho.di.core.database.Database.connect(Database.java:303)
      5. org.pentaho.di.core.database.Database.connect(Database.java:291)
      6. org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:86)
      7. org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2382)
      7 frames
    8. org.pentaho.ui
      DataHandler.testDatabaseConnection
      1. org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:541)
      1 frame
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    10. org.pentaho.ui
      SwingButton$OnClickRunnable.run
      1. org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:329)
      2. org.pentaho.ui.xul.swing.tags.SwingButton$OnClickRunnable.run(SwingButton.java:58)
      2 frames
    11. Java RT
      Dialog.setVisible
      1. java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
      2. java.awt.EventQueue.dispatchEventImpl(EventQueue.java:682)
      3. java.awt.EventQueue.access$000(EventQueue.java:85)
      4. java.awt.EventQueue$1.run(EventQueue.java:643)
      5. java.awt.EventQueue$1.run(EventQueue.java:641)
      6. java.security.AccessController.doPrivileged(Native Method)
      7. java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      8. java.awt.EventQueue.dispatchEvent(EventQueue.java:652)
      9. java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
      10. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
      11. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:205)
      12. java.awt.Dialog$1.run(Dialog.java:1044)
      13. java.awt.Dialog$3.run(Dialog.java:1096)
      14. java.security.AccessController.doPrivileged(Native Method)
      15. java.awt.Dialog.show(Dialog.java:1094)
      16. java.awt.Component.show(Component.java:1584)
      17. java.awt.Component.setVisible(Component.java:1536)
      18. java.awt.Window.setVisible(Window.java:841)
      19. java.awt.Dialog.setVisible(Dialog.java:984)
      19 frames
    12. org.pentaho.ui
      SwingDialog.show
      1. org.pentaho.ui.xul.swing.tags.SwingDialog.show(SwingDialog.java:238)
      1 frame
    13. org.pentaho.reporting
      ConnectionEditorPanel$AddDataSourceAction.actionPerformed
      1. org.pentaho.reporting.designer.extensions.connectioneditor.XulDatabaseDialog.open(XulDatabaseDialog.java:228)
      2. org.pentaho.reporting.designer.extensions.connectioneditor.ConnectionEditorPanel$AddDataSourceAction.actionPerformed(ConnectionEditorPanel.java:177)
      2 frames
    14. Java RT
      Dialog.setVisible
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028)
      2. javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
      6. java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
      7. java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:272)
      8. java.awt.Component.processMouseEvent(Component.java:6375)
      9. javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      10. java.awt.Component.processEvent(Component.java:6140)
      11. java.awt.Container.processEvent(Container.java:2083)
      12. java.awt.Component.dispatchEventImpl(Component.java:4737)
      13. java.awt.Container.dispatchEventImpl(Container.java:2141)
      14. java.awt.Component.dispatchEvent(Component.java:4565)
      15. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4619)
      16. java.awt.LightweightDispatcher.processMouseEvent(Container.java:4280)
      17. java.awt.LightweightDispatcher.dispatchEvent(Container.java:4210)
      18. java.awt.Container.dispatchEventImpl(Container.java:2127)
      19. java.awt.Window.dispatchEventImpl(Window.java:2482)
      20. java.awt.Component.dispatchEvent(Component.java:4565)
      21. java.awt.EventQueue.dispatchEventImpl(EventQueue.java:684)
      22. java.awt.EventQueue.access$000(EventQueue.java:85)
      23. java.awt.EventQueue$1.run(EventQueue.java:643)
      24. java.awt.EventQueue$1.run(EventQueue.java:641)
      25. java.security.AccessController.doPrivileged(Native Method)
      26. java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      27. java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
      28. java.awt.EventQueue$2.run(EventQueue.java:657)
      29. java.awt.EventQueue$2.run(EventQueue.java:655)
      30. java.security.AccessController.doPrivileged(Native Method)
      31. java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      32. java.awt.EventQueue.dispatchEvent(EventQueue.java:654)
      33. java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
      34. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
      35. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:205)
      36. java.awt.Dialog$1.run(Dialog.java:1044)
      37. java.awt.Dialog$3.run(Dialog.java:1096)
      38. java.security.AccessController.doPrivileged(Native Method)
      39. java.awt.Dialog.show(Dialog.java:1094)
      40. java.awt.Component.show(Component.java:1584)
      41. java.awt.Component.setVisible(Component.java:1536)
      42. java.awt.Window.setVisible(Window.java:841)
      43. java.awt.Dialog.setVisible(Dialog.java:984)
      43 frames
    15. org.pentaho.reporting
      ConnectionEditorAction.actionPerformed
      1. org.pentaho.reporting.libraries.designtime.swing.CommonDialog.setVisible(CommonDialog.java:280)
      2. org.pentaho.reporting.libraries.designtime.swing.CommonDialog.performEdit(CommonDialog.java:193)
      3. org.pentaho.reporting.designer.extensions.connectioneditor.ConnectionEditorDialog.performEditConnections(ConnectionEditorDialog.java:60)
      4. org.pentaho.reporting.designer.extensions.connectioneditor.ConnectionEditorAction.actionPerformed(ConnectionEditorAction.java:45)
      4 frames
    16. Java RT
      EventDispatchThread.run
      1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2028)
      2. javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2351)
      3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
      4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
      5. javax.swing.AbstractButton.doClick(AbstractButton.java:389)
      6. javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:809)
      7. com.apple.laf.AquaMenuItemUI.doClick(AquaMenuItemUI.java:137)
      8. javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:850)
      9. java.awt.Component.processMouseEvent(Component.java:6375)
      10. javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
      11. java.awt.Component.processEvent(Component.java:6140)
      12. java.awt.Container.processEvent(Container.java:2083)
      13. java.awt.Component.dispatchEventImpl(Component.java:4737)
      14. java.awt.Container.dispatchEventImpl(Container.java:2141)
      15. java.awt.Component.dispatchEvent(Component.java:4565)
      16. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4619)
      17. java.awt.LightweightDispatcher.processMouseEvent(Container.java:4280)
      18. java.awt.LightweightDispatcher.dispatchEvent(Container.java:4210)
      19. java.awt.Container.dispatchEventImpl(Container.java:2127)
      20. java.awt.Window.dispatchEventImpl(Window.java:2482)
      21. java.awt.Component.dispatchEvent(Component.java:4565)
      22. java.awt.EventQueue.dispatchEventImpl(EventQueue.java:684)
      23. java.awt.EventQueue.access$000(EventQueue.java:85)
      24. java.awt.EventQueue$1.run(EventQueue.java:643)
      25. java.awt.EventQueue$1.run(EventQueue.java:641)
      26. java.security.AccessController.doPrivileged(Native Method)
      27. java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      28. java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
      29. java.awt.EventQueue$2.run(EventQueue.java:657)
      30. java.awt.EventQueue$2.run(EventQueue.java:655)
      31. java.security.AccessController.doPrivileged(Native Method)
      32. java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
      33. java.awt.EventQueue.dispatchEvent(EventQueue.java:654)
      34. java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:296)
      35. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:211)
      36. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:201)
      37. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:196)
      38. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:188)
      39. java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
      39 frames