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'
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: