Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to connect Pentaho bi server to Databricks

  1. #1
    Join Date
    Dec 2015
    Posts
    1

    Default How to connect Pentaho bi server to Databricks

    Hi

    This is not a easy question because Databricks is not a well know database.

    But in fact it's the same as connect pentaho to Spark 1.5.2.

    There no default configuration in Pentaho Datasource to work with spark.
    In fact the JDBC url is the same as hive2.

    But actually I can't connect with pentaho I get this exception:
    java.sql.SQLException: Unable to load Hive JDBC driver for the currently active Hadoop configuration
    at org.apache.hadoop.hive.jdbc.HiveDriver.getActiveDriver(HiveDriver.java:108)
    at org.apache.hadoop.hive.jdbc.HiveDriver.callWithActiveDriver(HiveDriver.java:122)
    at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:140)

    java.sql.SQLException: Unable to load Hive JDBC driver for the currently active Hadoop configuration
    at org.apache.hadoop.hive.jdbc.HiveDriver.getActiveDriver(HiveDriver.java:108)
    at org.apache.hadoop.hive.jdbc.HiveDriver.callWithActiveDriver(HiveDriver.java:122)
    at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:140)

    Caused by: org.pentaho.di.core.hadoop.NoShimSpecifiedException: Active configuration not set. Aborting initialization.
    at org.pentaho.di.core.hadoop.HadoopConfigurationBootstrap.initProvider(HadoopConfigurationBootstrap.java:149)
    at org.pentaho.di.core.hadoop.HadoopConfigurationBootstrap.getProvider(HadoopConfigurationBootstrap.java:129)
    at org.pentaho.di.core.hadoop.HadoopConfigurationBootstrap.getHadoopConfigurationProvider(HadoopConfigurationBootstrap.java:




    Could you help me
    Thanks

  2. #2
    Join Date
    Jun 2016
    Posts
    1

    Default Pentaho BA Reporting through Databricks Spark

    Looking to do something similar. Any hints?

    Quote Originally Posted by richiesgr View Post
    Hi

    This is not a easy question because Databricks is not a well know database.

    But in fact it's the same as connect pentaho to Spark 1.5.2.

    There no default configuration in Pentaho Datasource to work with spark.
    In fact the JDBC url is the same as hive2.

    But actually I can't connect with pentaho I get this exception:
    java.sql.SQLException: Unable to load Hive JDBC driver for the currently active Hadoop configuration
    at org.apache.hadoop.hive.jdbc.HiveDriver.getActiveDriver(HiveDriver.java:108)
    at org.apache.hadoop.hive.jdbc.HiveDriver.callWithActiveDriver(HiveDriver.java:122)
    at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:140)

    java.sql.SQLException: Unable to load Hive JDBC driver for the currently active Hadoop configuration
    at org.apache.hadoop.hive.jdbc.HiveDriver.getActiveDriver(HiveDriver.java:108)
    at org.apache.hadoop.hive.jdbc.HiveDriver.callWithActiveDriver(HiveDriver.java:122)
    at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:140)

    Caused by: org.pentaho.di.core.hadoop.NoShimSpecifiedException: Active configuration not set. Aborting initialization.
    at org.pentaho.di.core.hadoop.HadoopConfigurationBootstrap.initProvider(HadoopConfigurationBootstrap.java:149)
    at org.pentaho.di.core.hadoop.HadoopConfigurationBootstrap.getProvider(HadoopConfigurationBootstrap.java:129)
    at org.pentaho.di.core.hadoop.HadoopConfigurationBootstrap.getHadoopConfigurationProvider(HadoopConfigurationBootstrap.java:




    Could you help me
    Thanks

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.