Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Pentaho Data Integration Stuido not able to conect HIVE2

  1. #1
    Join Date
    Jun 2013
    Posts
    2

    Default Pentaho Data Integration Stuido not able to conect HIVE2

    Hi

    Using the trial version for evaluation

    Trying to connect HIVE2 server implementation through Pentaho Data Integration but not able to connect. Getting below error message

    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)
    Could not establish connecton to jdbc:hive://10.80.31.69:10000/default: java.net.SocketException: Malformed reply from SOCKS server

    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)
    Could not establish connecton to jdbc:hive://10.80.31.69:10000/default: java.net.SocketException: Malformed reply from SOCKS server

    at org.pentaho.di.core.database.Database.normalConnect(Database.java:366)
    at org.pentaho.di.core.database.Database.connect(Database.java:315)
    at org.pentaho.di.core.database.Database.connect(Database.java:277)
    at org.pentaho.di.core.database.Database.connect(Database.java:267)
    at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:86)
    at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2469)
    at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:535)
    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:329)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:26)
    at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:119)
    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.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:378)
    at org.pentaho.ui.xul.swt.tags.SwtDialog.show(SwtDialog.java:304)
    at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:115)
    at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:62)
    at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.newConnection(SpoonDBDelegate.java:493)
    at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.newConnection(SpoonDBDelegate.java:478)
    at org.pentaho.di.ui.spoon.Spoon.newConnection(Spoon.java:7849)
    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:329)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:139)
    at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:123)
    at org.pentaho.ui.xul.jface.tags.JfaceMenuitem.access$100(JfaceMenuitem.java:26)
    at org.pentaho.ui.xul.jface.tags.JfaceMenuitem$1.run(JfaceMenuitem.java:85)
    at org.eclipse.jface.action.Action.runWithEvent(Action.java:498)
    at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545)
    at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490)
    at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402)
    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:1219)
    at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7042)
    at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:8302)
    at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:578)
    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:134)
    Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
    Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver)
    Could not establish connecton to jdbc:hive://10.80.31.69:10000/default: java.net.SocketException: Malformed reply from SOCKS server
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:502)
    at org.pentaho.di.core.database.Database.normalConnect(Database.java:350)
    ... 55 more
    Caused by: java.sql.SQLException: Could not establish connecton to jdbc:hive://10.80.31.69:10000/default: java.net.SocketException: Malformed reply from SOCKS server
    at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:113)
    at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
    at org.apache.hadoop.hive.jdbc.HiveDriver$1.call(HiveDriver.java:126)
    at org.apache.hadoop.hive.jdbc.HiveDriver$1.call(HiveDriver.java:123)
    at org.apache.hadoop.hive.jdbc.JDBCDriverCallable.callWithDriver(JDBCDriverCallable.java:57)
    at org.apache.hadoop.hive.jdbc.HiveDriver.callWithActiveDriver(HiveDriver.java:112)
    at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:123)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:482)
    ... 56 more
    Hostname : 10.80.31.69
    Port : 10000
    Database name : default


    Read in some of the blogs about Pentaho is not providing any connection to HIVE2. Is it true

    Regards
    Gorav Goyal

  2. #2
    Join Date
    Jun 2013
    Posts
    1

    Default

    Hi,

    I've the same issue and unfortunately not have the solution. I use by default "pentaho-hadoop-hive-jdbc-shim-1.3.0".
    Thanks for any help.

    OD

  3. #3
    Join Date
    Sep 2012
    Posts
    71

    Default

    Looks like you are using the Hive 1 driver to try and connect to a Hive 2 server, which Hive does not allow. If "Hadoop Hive 2" is in your list of Database types, use that. If it is not, you should upgrade your Big Data plugin (and pentaho-hadoop-hive-jdbc-shim JAR) to the latest (currently 1.3.3.1). If you're a Pentaho customer the files and instructions are available via Support:

    https://support.pentaho.com/home

    If not, PDI 4.4.2 Community Edition (CE) should be released very soon, or you can download the artifacts from the Continuous Integration server (http://ci.pentaho.com/view/Big%20Dat...ta-plugin-1.3/)

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.