Accessing Hive Metastore DB on CDP Public Cloud

[#1]

Perform the following steps to access the Hive MetaStore:
===========================================

1. SSH to the Data lake CM Node as 'cloudbreak' user.
2. Run 'sudo -i' to gain root access.
3. source activate_salt_env
4. export PGPASSWORD=$(salt-call pillar.get postgres:hive:remote_admin_pw| tail -n 1 | awk '{print $1}')
5. HIVE_DB=$(salt-call pillar.get postgres:hive:database| tail -n 1 | awk '{print $1}')
6. HIVE_DB_REMOTE_ADM=$(salt-call pillar.get postgres:hive:remote_admin| tail -n 1 | awk '{print $1}')
7. HIVE_DB_REMOTE_PORT=$(salt-call pillar.get postgres:hive:remote_db_port| tail -n 1 | awk '{print $1}')
8. HIVE_DB_REMOTE_URL=$(salt-call pillar.get postgres:hive:remote_db_url| tail -n 1 | awk '{print $1}')
9. psql -h ${HIVE_DB_REMOTE_URL} -U ${HIVE_DB_REMOTE_ADM} -p ${HIVE_DB_REMOTE_PORT} -d ${HIVE_DB}