SAP BO and Hive connectivity using JDBC

[Former Member]

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

[former_member187093]

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!!!

[former_member136842]

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.

[Former Member]

Hi Sebastian,

Thanks for your reply. We tried setting up path varibale and restarted tomcat and SIA.

Still it is giving the same error.

Thanks and Regards,

Atul

[Former Member]

Hi Atul,

Thank for the screenshot.

Please try adding the full path of the jar files which you have added for hadoop

database in the sbo files :

1. Configure the hive.sbo (location: "Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\hive.sbo") with jar file

entries.

Add

<DataBase Active="Yes" Name="Apache Hadoop HIVE">

<JDBCDriver>

<ClassPath>

<Path>C:\\<path of the jar file>\\name of the jar file </Path>

<Path>C:\\<path of the jar file>\\name of the jar file </Path>

<Path>C:\\<path of the jar file>\\name of the jar file </Path>

</ClassPath>

...

</JDBCDriver>

2. After configuring hive.sbo file start the connection server.

Kindly let me know if the issue still persists.

Regards,

Nakul Mehta

[Former Member]

Hi Nakul,

Thanks for your reply. We have tried solution provided by you.

but now we are getting a new error saying "Method not supported".

We are using greenplum hadoop version 1.0.3 and we have apache hadoop 20.2,

Please let me know which version is compatible with BO4.0.

Best Regards,

Atul

[maciej_nowinski]

Hi Atul,

I'm facing the same situation, did you solve this problem?

Best Regards,

Maciej Nowinski

[Former Member]

Hi Maciej,

Yes we have solved the problem.

We added one more jar file named "libthrift.jar" and we gave read and execute permission to all the jar files.

Make sure you update your hive.sbo file with the new jar file entry.

Best Regards,

Atul

[Former Member]

Hi Atul,

What is the port you have used to connect to Hadoop from within IDT. IS that 6400 or some others.

Thanks

Mallik

[Former Member]

Hi Mallikarjuna,

I am getting following error,

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

Thanks.