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.
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.
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?
I have HIVE running, here is my path for HiveJDBC41.jar (v 2.6) (From Cloudera):
It also depends on your JRE version you have configured under JRE Installation Path under the configuration tab -> Settings.
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