Home

Configuring Microsoft JDBC to connect to Hive Metastore

  1. Download Microsoft JDBC Driver 7.0 for SQL Server JAR from Microsoft here to Unravel node.

  2. Extract the downloaded file.

    tar -xvzf sqljdbc_version_enu.tar.gz

  3. Create the following directories if they do not exist.

    mkdir -p /usr/local/unravel/share/java
mkdir -p /usr/local/unravel/dlib/mybatis

  4. Copy mssql-jdbc-7.0.0.jre8.jar to the following locations.

    sudo cp sqljdbc_7.0/enu/mssql-jdbc-7.0.0.jre8.jar /usr/local/unravel/share/java
sudo cp sqljdbc_7.0/enu/mssql-jdbc-7.0.0.jre8.jar /usr/local/unravel/dlib/mybatis

  5. Change the following properties in /usr/local/unravel/etc/unravel.properties.

    javax.jdo.option.ConnectionURL=jdbc:sqlserver://jdbc_url
javax.jdo.option.ConnectionDriverName=com.microsoft.sqlserver.jdbc.SQLServerDriver

  6. Restart unravel_tw daemon.

    sudo /etc/init.d/unravel_tw restart
In this section: