Support for LOCAL user installs. If you have installed previously as the 'root' user, following these directions to remove that and start using the local user reference:
https://github.com/dstreev/cloudera_upgrade_utils/tree/master/hive-sre#get-the-binary
The key is the local PATH order. OR as the root user, remove the following from your system:
sudo rm -rf /usr/local/hive-sre
sudo rm /usr/local/bin/hive-sre*