Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Hive Issue

  1. #1

    Default Hive Issue - JDBC Connection Problems

    Edited to reflect the solution:

    I am running PDI 5.2 GA and the Cloudera Quickstart VM 4.7 running on VirtualBox. Despite my best efforts, I can not create a JDBC connection to Hive (hive2 server).

    The first error when trying the 'Hadoop Hive 2' type is:

    "Error connecting to database: (using class org.apache.hive.jdbc.HiveDriver)
    Java heap space". To fix this error, I gave PDI 4096m in the Spoon.bat file.

    After fixing this error, I hit another:

    "Error connecting to database: (using class org.apache.hive.jdbc.HiveDriver)
    Could not establish connection to jdbc:hive2://localhost.localdomain:10000/default: null"

    I needed to make a few changes. I added parameter "auth" and the value "noSasl".

    I also had to add a Virtual Box port forwarding rule - host port 10001, guest port 10000.

    Hope this helps.

    Chris
    Breadboardbi.com
    Last edited by clavigne; 01-14-2015 at 10:00 AM.

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.