How do I connect Yellowfin to a Hive Server 2 configuration?

Connecting to Hiveserver2: provided by client Bas

The default database driver shipped with Yellowfin is not compatible with Hiveserver2. To get this up and running follow the instructions below.

1. Copy files: Copy the following files to a folder somewhere on the Yellowfin server:

/usr/lib/hadoop/ (path in Hortonworks HDP2.1)

hadoop-common-2.4.0.2.1.4.0-632.jar

/usr/lib/hive/lib (path in Hortonworks HDP2.1)

commons-codec-1.4.jar
commons-logging-1.1.3.jar
guava-11.0.2.jar
hive-common-0.13.0.2.1.4.0-632.jar
hive-jdbc-0.13.0.jar
hive-service-0.13.0.jar
httpclient-4.2.5.jar
httpcore-4.2.5.jar
libthrift-0.9.0.jar
slf4j-api-1.7.7.jar

2. Change ownership and permissions:

cd /opt/Yellowfin/appserver/webapps/ROOT/WEB-INF/lib
sudo chown yellowfin:yellowfin *
sudo chmod 644 *

NOTE: yellowfin is the user who runs the yellowfin proces

3. Edit file:

Add the following at the bottom of the JDBCDrivers section in '/opt/Yellowfin/appserver/webapps/ROOT/WEB-INF/web.xml'

org.apache.hive.jdbc.HiveDriver


NOTE: dont forget to end the line above the newly pasted line with a comma

4. Restart Yellowfin:

cd /opt/yellowinf/appserver/bin
sudo su yellowfin -c ./shutdown.sh
sudo su yellowfin -c ./startup.sh

NOTE: yellowfin is the user who runs the yellowfin process

5. Create Data Source:

Connection method: JDBC
Database: Apache Hive 2
Driver Path: /opt/Yellowfin/appserver/webapps/ROOT/WEB-INF/lib

6. Test connection:

EDIT: extra file guava-11.0.2.jar
Is article helpful?