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

  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

  5. In /usr/local/unravel/etc/unravel.properties, edit the following properties:

    Tip

    To locate the values for the above properties see Obtaining Hive Metastore details.

    For example,

    javax.jdo.option.ConnectionURL=jdbc:sqlserver://jdbc_url
javax.jdo.option.ConnectionDriverName=com.microsoft.sqlserver.jdbc.SQLServerDriver
javax.jdo.option.ConnectionPassword=hive-metastore-database-password 
javax.jdo.option.ConnectionUserName=hive-metastore-database-user

  6. Restart Unravel Server.

    sudo /etc/init.d/unravel_all.sh restart
In this section: