Summary
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 process
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: don't 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
Ensure you can now connect. If it's now working, make a cup of coffee!
Any issues, please contact Support.