Skip to Content
0

Apache Hive2.1 Connection with SAP BO BI SP05

Feb 03, 2017 at 11:07 AM

47

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Feb 03, 2017 at 11:39 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded