How to Set Up Hive Metastore on SQL Server with Hive 2.0-2.2
When you set up a Hive external metastore on SQL Server, it fails due to HIVE-14698.
Hive 2.0 through 2.2.
To resolve this issue, import the notebook and follow the instructions. The instructions in this notebook refer to Hive 2.1. However, the instructions can be used without alteration for Hive 2.0 and 2.2 as well.
External metastore setup Hive 2.1 with SQL Server notebook