Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Issues configuring Pentaho pdi 4.3 db connection with hadoop - hive instances

  1. #1

    Default Issues configuring Pentaho pdi 4.3 db connection with hadoop - hive instances

    I am having issues getting PDI 4.3.0 configured to work with my instances of Hadoop and Hive. Here are my specifics....

    1) hadoop-0.20.2-cdh3u4
    2) hive-0.7.1-cdh3u4
    3) PDI 4.3.0

    I have followed a few guides on getting this setup. Here are the steps I have followed.

    1) Copied hadoop-core-0.20.2-cdh3u4.jar to <install dir>/data-integration/libext/bigdata/

    2) Copied guava-r09-jarjar to <install dir>/data-integration/libext/bigdata/

    3) Have the following jar files in <install dir>\data-integration\libext\bigdata\hive

    I then started PDI.

    I went to new Database Connection window. I picked Hadoop Hive, gave the connection a name, provided the host name (my-server-host-name), database name (default), port number (9000) and selected Native (JDBC) from the Access pane.

    Currently I get the following error:

    Error connecting to database: (using class org.apache.hadoop.hive.jdbc.HiveDriver);

    Please help.

  2. #2
    Join Date
    Aug 2010


    Make sure you remove the hadoop-core-0.20.2.jar we ship in libext/bigdata. I'm guessing it's still there.

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.