Downgrade each Hive Metastore server one at a time, as described below. There is no order that needs to be followed.
Note: Existing connections to the Metastore will be dropped during this process, and there is a chance that running CLI jobs may fail. However, the Metastore will automatically retry any failed jobs.
Find the Hive Metastore server process ID and stop the process. For example:
# ps aux | grep hive ... hive 129414 0.1 3.3 2002400 131332 ... org.apache.hadoop.hive.metastore.HiveMetaStore ... # kill 129414
Switch to the previous software version and start the server:
hdp-select set hive-metastore 2.2.0.0-2041
su - hive -c "nohup /usr/hdp/current/hive-metastore/bin/hive --service metastore>/var/log/hive/hive.out 2>/var/log/hive/hive.log &"
Validate the downgrade process: make sure that the following jobs run successfully.
Hive/MapReduce job
Hive/Tez job
Continue with the next downgrade step.