If you are using MS SQL Server for Hive and Oozie metastores, you must install the MS SQL Server JDBC driver after installing Hive or Oozie.
Download the SQL JDBC JAR file sqljdbc_3.0.1301.101_enu.exe.
Run the downloaded file.
(By default, the SQL JDBC driver file is extracted to
Downloads\Microsoft SQL Server JDBC Driver 3.0.)
Copy and paste
Downloads\Microsoft SQL Server JDBC Driver 3.0\sqljdbc_3.0\enu\sqljdbc4.jar
toHIVE_HOME/lib
(whereHIVE_HOME
can be set toD:\hadoop\hive-0.9.0
).