2.4.1. (Optional) Install Microsoft SQL Server JDBC Driver

If you are using MS SQL Server for Hive and Oozie metastores, you must install the MS SQL Server JDBC driver.

  1. Download the SQL JDBC JAR file sqljdbc_3.0.1301.101_enu.exe.

  2. Run the downloaded file.

    (By default, the SQL JDBC driver file will be extracted at C:\Users\Administrator\Downloads\Microsoft SQL Server JDBC Driver 3.0.)

  3. Copy and paste the C:\Users\Administrator\Downloads\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc4.jar file to $HIVE_HOME/lib (where $HIVE_HOME can be set to D:\hadoop\hive-0.9.0).