4. Upgrade Hive and HCatalog

Upgrade Hive and HCatalog. On the Hive and HCatalog host machines, execute the following command:s
- For RHEL/CentOS:
```
yum upgrade hive hcatalog
                
```
- For SLES:
```
zypper update hive hcatalog
              
```

On the Hive host machine, edit the /etc/hive/conf/hive-site.xml file and add the following property:

<property>
   <name>hive.server2.enable.doAs</name>
   <value>true</value>
 </property> 
<property>
   <name>fs.hdfs.impl.disable.cache</name>
   <value>true</value>
 </property>

Source the upgrade script. Execute the following command from the Hive Metastore Server:

cd /usr/lib/hive/scripts/metastore/upgrade/mysql/
 mysql -uhive -phive -h $fully.qualified.domain.name_for_Hive_hostmachine hivemysql> source upgrade-0.9.0-to-0.10.0.mysql.sql

On the Hive host machine, edit /usr/lib/hive/conf/hive-env.sh file and edit the HIVE_AUX_JARS_PATH parameter as shown below:
```
export HIVE_AUX_JARS_PATH=/usr/lib/hcatalog/share/hcatalog/hcatalog-core.jar
```
Start Hive. On the Hive Metastore host machine, execute the following command:
```
 sudo su -l hive -c "nohup hive --service metastore > $HIVE_LOG_DIR/hive.out 2> $HIVE_LOG_DIR/hive.log &" 
 
                    
```
where $HIVE_LOG_DIR is the directory where Hive server logs are stored (example: /var/log/hive).
Start Hive Server2. On the Hive Server2 host machine, execute the following command:
```
 sudo su -l hive -c "nohup /usr/lib/hive/bin/hiveserver2 -hiveconf hive.metastore.uris=\" \" > $HIVE_LOG_DIR/hiveserver2.out 2> $HIVE_LOG_DIR/hiveserver2.log &" 
                    
```
where $HIVE_LOG_DIR is the directory where Hive server logs are stored (example: /var/log/hive).

Legal notices