Skip to Content
avatar image
Former Member

Apache Hive2.1 Connection with SAP BO BI SP05

Hi

I am trying to connect Apache hive 2.1 to SAP BI and facing issues, Please let me know what steps need to be taken care before establishing the connection.

Please find the details of Hive , SAP BI, OS, Driver details:

1. Which Business Objects Client/Server Product + version + service pack + hot fixes do you use? (for example: BO 4.1 SP 6 FP 1)

Ans:SAP BI 4.1 SP 05

2. What is the operating system + version you are using? (for BI server and client)

Ans: Red Hat Enterprise Linux Server release 6.4 (Santiago)

3. What is the exact version of your HIVE database?

Ans: hive 2.1.0

4.What is the JDBC middleware version of it?

Ans:Apache Hadoop Hive 0.13 Simba JDBC4 Hiveserver2

Using IDT trying to create connection and while testing the connection, I am getting the error

Error:[Simba][HiveJDBCDriver](500310) Invalid operation: null;

Any inputs will be greatly appreciated:

Thanks

Sarvesh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 03, 2017 at 11:39 AM

    I don't have idea about Hadoop.I found some links and notes.check if these are useful.

    See mention sap note and perform mentioned steps to test the JDBC connectivity.

    2141111 - How to: Test JDBC Connectivity on UNIX/Linux

    https://wiki.scn.sap.com/wiki/display/BOBJ/Apache+Hadoop+Hive+Connection+With+Information+Design+Tool

    Add comment
    10|10000 characters needed characters exceeded