If you are using MS SQL Server for Hive and Oozie metastores, you must install the MS SQL Server JDBC driver.
Download the SQL JDBC JAR file sqljdbc_3.0.1301.101_enu.exe.
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
.)Copy and paste the
C:\Users\Administrator\Downloads\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc4.jar
file to
(where$HIVE_HOME
/lib$HIVE_HOME
can be set toD:\hadoop\hive-0.9.0
).