How to Set Up Hive Metastore on SQL Server with Hive 2.0-2.2

Problem

When you set up a Hive external metastore on SQL Server, it fails due to HIVE-14698.

Version

Hive 2.0 through 2.2.

Solution

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

Get notebook