Skip to Content
avatar image
Former Member

SAP BO and Hive connectivity using JDBC

Dear All,

we are trying to implement connectivity between SAP BO and hive using JDBC.

We have performed following steps as per the data access guide.

To create a connection to the
Hive Thrift server, you first have to place the following sets of JAR files to the connectionserver-install-dir\connectionServer\jdbc\drivers\hive directory

JAR files HIVE database version

 

hadoop-0.20.1-core.jar or hadoop-core-0.20.2.jar

hive-exec-0.7.1.jar

hive-jdbc-0.7.1.jar

hive-metastore-0.7.1.jar

hive-service-0.7.1.jar

libfb303.jar

log4j-1.2.16.jar

commons-logging-1.0.4.jar

slf4j-api-1.6.1.jar

slf4j-log4j12-1.6.1.jar

But now are getting error while trying to connect using IDT.

"org.apache.hadoop.hive.jdbc.HiveDriver"

Best Regards,

Atul Dumbre

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 25, 2013 at 01:24 PM

    Hi,

    JDBC Drivers need usually also available in the PATH Variable. I would recommend you add the above path to the PATH Variable, restart Tomcat and your SIA and try again.

    Regards

    -Seb.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Mallikarjuna,

      I am getting following error,

      [Simba][HiveJDBCDriver](500153) Error in set hive server type: null.

      Thanks.

  • Jul 01, 2016 at 11:09 AM

    we did connect hive via JDBC.  as per the error, the driver is not able to get the server details

    is kerberos used by any chance?

    check the driver version and try to test the connection.  there is a note for this, please refer the note and try again. hope this helps!!!

    Add comment
    10|10000 characters needed characters exceeded