3. (Microsoft SQL Server Only:) Configure Hive when Metastore DB is in a Named Instance

If your site uses Microsoft SQL Server for the Hive metadata store and the Hive database is not in the default instance (that is, in a named instance), you must configure the connection string after the installation completes:

  1. On the Hive host, open the hive-site.xml file in a text editor.

  2. Add the instance name to the property of the connection URL:

    <description>JDBC connect string for a JDBC metastore</description> 


    • sql-host is the SQL Server host name

    • instance-name is the name of the instance that the Hive database is in

    • hive_db is the name of the Hive database

  3. Save the changes to hive-site.xml.

  4. Finish configuring Hive as described later in this chapter, before restarting the Apache Hadoop Hive service.

loading table of contents...