All Apps and Add-ons

DB Connect 3.1.3 Hive connection

aaronbarry73
Path Finder

I am trying to install the Hive driver so that I can send Splunk data to the company's hadoop instance.

I found two articles that had some good details. Each uses a different method. I tried both and I haven't yet been successful.

1) https://answers.splunk.com/answers/575488/db-connect-3-hive-connection.html
The answer in this thread seems to indicate that I can drop the connection jar file, HiveJDBC4.jar into $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers/ and then the rest of the supporting files from the Cloudera zip file go into a new directory $SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers/HiveJDBC4-lib/.

I tried this and then reloaded the drivers page in Splunk web, Hive driver still shows not installed.

2) https://www.splunk.com/blog/2015/02/25/splunk-db-connect-cloudera-hive-jdbc-connector.html
This blog post indicated that the driver should go in $SPLUNK_HOME/etc/apps/dbx/bin/lib. I'm assuming that would mean $SPLUNK_HOME/etc/apps/splunk_app_db_connect/bin/lib. I don't have this path. I tried adding a new lib directory into the bin directory and then unzipping the Cloudera file here. THen I created database_types.conf and added it to $SPLUNK_HOME/etc/apps/splunk_app_db_connect/local/. I reloaded the drivers page and still not showing that hive is installed.

Any thoughts on what else I could try or what I am doing wrong?

Thanks!

0 Karma

Nikitha
Explorer

Hi - did you manage to solve the issue ? I am also stuck in a similar situation

0 Karma

lroynsky
Explorer

I have HIVE running, here is my path for HiveJDBC41.jar (v 2.6) (From Cloudera):

$SPLUNK_HOME/etc/apps/splunk_app_db_connect/drivers

It also depends on your JRE version you have configured under JRE Installation Path under the configuration tab -> Settings.

0 Karma

rdagan_splunk
Splunk Employee
Splunk Employee

Option # 1, is the right option for DB Connect version 3.
Are you using HiveJDBC4.jar or HiveJDBC41.jar?

It looks like HiveJDBC41.jar and supporting files are for JDK 1.7 and above

Get Updates on the Splunk Community!

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...

From Alert to Resolution: How Splunk Observability Helps SREs Navigate Critical ...

It's 3:17 AM, and your phone buzzes with an urgent alert. Wire transfer processing times have spiked, and ...