Forum

This content is now out of date.

Visit Our Community

Connecting to Hiveserver2

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

King regards,

Bas

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

/usr/lib/hadoop/ (path in Hortonworks HDP2.1)
[code]hadoop-common-2.4.0.2.1.4.0-632.jar[/code]

/usr/lib/hive/lib (path in Hortonworks HDP2.1)
[code]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[/code]

## 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

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

[code]org.apache.hive.jdbc.HiveDriver[/code]

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

## 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 proces


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

Test connection

[quote="">EDIT: extra file guava-11.0.2.jar[/quote]
NICE!

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.