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:
On the Hive host, open the
hive-site.xml
file in a text editor.Add the instance name to the property of the connection URL:
<property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:sqlserver://sql-host/instance-name:port/hive_db;create=true</value> <description>JDBC connect string for a JDBC metastore</description> </property>
where:
sql-host
is the SQL Server host nameinstance-name
is the name of the instance that the Hive database is inhive_db
is the name of the Hive database
Save the changes to
hive-site.xml
.Finish configuring Hive as described later in this chapter, before restarting the Apache Hadoop Hive service.