Use the following instructions to set up the Hive/HCatalog configuration files:
Extract the Hive/HCatalog configuration files to a temporary directory.
The files are located in
configuration_files/hive
where you decompressed the companion files.Modify the configuration files.
In the temporary directory, locate the following file and modify the properties based on your environment. Search for
TODO
in the files for the properties to replace.Edit
hive-site.xml
and modify the following properties:<property> <name>javax.jdo.option.ConnectionURL</name> <value>jdbc:mysql://$mysql.full.hostname:3306/$database.name?createDatabaseIfNotExist=true</value> <description>Enter your JDBC connection string. </description> </property>
<property> <name>javax.jdo.option.ConnectionUserName</name> <value>$dbusername</value> <description>Enter your MySQL credentials. </description> </property>
<property> <name>javax.jdo.option.ConnectionPassword</name> <value>$dbuserpassword</value> <description>Enter your MySQL credentials. </description> </property>
Enter your MySQL credentials from Install MySQL (Optional).
<property> <name>hive.metastore.uris</name> <value>thrift://$metastore.server.full.hostname:9083</value> <description>URI for client to contact metastore server. To enable HiveServer2, leave the property value empty. </description> </property>
Copy the configuration files.
On all Hive hosts create the Hive configuration directory.
rm -r $HIVE_CONF_DIR ; mkdir -p $HIVE_CONF_DIR ;
Copy all the configuration files to
$HIVE_CONF_DIR
directory.Set appropriate permissions:
chown -R $HIVE_USER:$HADOOP_GROUP $HIVE_CONF_DIR/../ ; chmod -R 755 $HIVE_CONF_DIR/../ ;
where:
$HIVE_CONF_DIR
is the directory to store the Hive configuration files. For example,/etc/hive/conf
.$HIVE_USER
is the user owning the Hive services. For example,hive
.$HADOOP_GROUP
is a common group shared by services. For example,hadoop
.