US and Worldwide: +1 (866) 660-7555
Results 1 to 3 of 3

Thread: Can't connect hive from BI server User console

  1. #1
    Join Date
    Aug 2010
    Posts
    25

    Default Can't connect hive from BI server User console

    HI, I've installed CDH3B2 and Pentaho BIserver3.7RC1 on Ubuntu.
    It works fine with DI server and Spoon, Report Designer, Metadata Editor connected to Hive.
    Database connection to Hive from Enterprise console works such as test connection.
    However BI server User console can not connect Hive through New data Source.
    JDBC driver for Hive is not showed up on Database connection panel connectionType list even I copied hive-jdbc-0.5.0-pentaho-1.0.0.jar to /opt/pentaho/server/biserver-ee/tomcat/lib
    Please let me know how to connect Hive from BI server User Console.
    Any suggestion would be greatly appreciated.
    Satoru Funai

  2. #2
    Join Date
    Apr 2009
    Posts
    337

    Default

    forget the drop down... id suggest you create the connection from admin console, use that jndi in user console..

  3. #3
    Join Date
    Jan 2017
    Posts
    1

    Default

    Hi , did you got success in connecting Pentaho BI Server to hive DB from BIserver User console. I am getting the same error.
    I can although connect from Spoon ,Metdata Editor etc..
    Kindly suggest

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
  •