Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: No suitable driver found for jdbc:hive - Spoon Database connections to Hadoop Hive

  1. #1

    Default No suitable driver found for jdbc:hive - Spoon Database connections to Hadoop Hive

    PDI Database connections to Hadoop Hive failing with message no suitable driver found for jdbc:hive:

    I have installed Pentaho BA Server 6.1 on Windows environment and Hortonworks Sandbox 2.4 on VMware Workstation.

    Pentaho and HDP2.4 integration is working fine for all the component except Hive.

    When I try to create database connection to Hadoop Hive in PDI Spoon, I get the following error.

    I tried copying hive-jdbc.jar (downloaded from HDP2.4 location /usr/hdp/2.4.0.0-169/hive/lib) to the locations in Pentaho (C:\Pentaho\server\biserver-ee\tomcat\lib and C:\Pentaho\server\data-integration-server\tomcat\lib) and this does not work and I get the same error. Any suggestion on this would be helpful.

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


    Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver)
    No suitable driver found for jdbc:hive://sandbox.hortonworks.com:10000/default




    at org.pentaho.di.core.database.Database.normalConnect(Database.java:466)
    at org.pentaho.di.core.database.Database.connect(Database.java:364)
    at org.pentaho.di.core.database.Database.connect(Database.java:335)
    at org.pentaho.di.core.database.Database.connect(Database.java:325)
    at org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerController.createDatabaseNodes(XulDatabaseExplorerController.java:380)
    at org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerController.init(XulDatabaseExplorerController.java:130)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.initialize(AbstractXulDomContainer.java:141)
    at org.pentaho.ui.xul.swt.SwtXulRunner$1.run(SwtXulRunner.java:67)
    at org.eclipse.swt.widgets.Synchronizer.syncExec(Unknown Source)
    at org.eclipse.swt.widgets.Display.syncExec(Unknown Source)
    at org.pentaho.ui.xul.swt.SwtXulRunner.initialize(SwtXulRunner.java:64)
    at org.pentaho.di.ui.core.database.dialog.XulDatabaseExplorerDialog.open(XulDatabaseExplorerDialog.java:92)
    at org.pentaho.di.ui.core.database.dialog.DataOverrideHandler.explore(DataOverrideHandler.java:84)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141)
    at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:43)
    at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:137)
    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.xul.KettleDialog.show(KettleDialog.java:88)
    at org.pentaho.di.ui.xul.KettleDialog.show(KettleDialog.java:55)
    at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:116)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:60)
    at org.pentaho.di.ui.job.entry.JobEntryDialog.showDbDialogUnlessCancelledOrValid(JobEntryDialog.java:270)
    at org.pentaho.di.ui.job.entry.JobEntryDialog$EditConnectionListener.widgetSelected(JobEntryDialog.java:373)
    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.pentaho.di.ui.job.entries.sql.JobEntrySQLDialog.open(JobEntrySQLDialog.java:430)
    at org.pentaho.di.ui.spoon.delegates.SpoonJobDelegate.editJobEntry(SpoonJobDelegate.java:259)
    at org.pentaho.di.ui.spoon.Spoon.editJobEntry(Spoon.java:8619)
    at org.pentaho.di.ui.spoon.job.JobGraph.editEntry(JobGraph.java:2892)
    at org.pentaho.di.ui.spoon.job.JobGraph.mouseDoubleClick(JobGraph.java:636)
    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.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1347)
    at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7989)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9269)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:662)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver)
    No suitable driver found for jdbc:hive://sandbox.hortonworks.com:10000/default


    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:579)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:450)
    ... 63 more
    Caused by: java.sql.SQLException: No suitable driver found for jdbc:hive://sandbox.hortonworks.com:10000/default
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:565)
    ... 64 more

  2. #2
    Join Date
    Feb 2017
    Posts
    5

    Default

    Did you find something ? We are facing the same problem....

  3. #3
    Join Date
    Jul 2017
    Posts
    1

    Default

    Any update? Facing the same issue...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.