Apache Hive2.1 Connection with SAP BO BI SP05

[Former Member]

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

[amitrathi239]

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+Too...