Steps to connect from Legacy Cluster to CDP Public Cloud Hive:   Build a connection string as follows using Hive Server Endpoint from DataHub by just adding the sslTrustStore and trustStorePassword along with workload username and password for PAM authentication. jdbc:hive2://master0.repro.cloudera/default;transportMode=http;httpPath=new/cdp-proxy-api/hive;ssl=true;sslTrustStore=gateway-client-trust.jks;trustStorePassword=*****;user=chella; Get the JKS file downloaded from CDP Knox (Token Integration) and copy it to HDP/CDH host. Get the latest JDBC jar "hive-jdbc-3.1.0-SNAPSHOT-standalone.jar" from CDW. CDP Control Plane > Management Console > Data Warehouse > click the 3 dots from any of Hive VW and "Download JDBC JAR" Copy the jar "hive-jdbc-3.1.0-SNAPSHOT-standalone.jar"  to HDP/CDH host. Get into beeline from HDP/CDH host Add the jar using the following command Beeline version 3.1.0.3.1.5.26-1 by Apache Hive 0: jdbc:hive2://c1544-node2> !addlocaldriverjar /root/hive-jdbc-3.1.0-SNAPSHOT-standalone.jar scan complete in 22ms Connect using the string we built in step [1] 0: jdbc:hive2://c1544-node2> !connect jdbc:hive2://master0.repro.cloudera/default;transportMode=http;httpPath=new/cdp-proxy-api/hive;ssl=true;sslTrustStore=gateway-client-trust.jks;trustStorePassword=*****;user=chella; Connecting to jdbc:hive2://master0.repro.cloudera/default;transportMode=http;httpPath=new/cdp-proxy-api/hive;ssl=true;sslTrustStore=gateway-client-trust.jks;trustStorePassword=*****;user=chella; Enter password for jdbc:hive2://master0.repro.cloudera/default: ************* Connected to: Apache Hive (version 3.1.3000.7.2.10.6-1) Driver: Hive JDBC (version 3.1.0.3.1.5.26-1) Transaction isolation: TRANSACTION_REPEATABLE_READ 1: jdbc:hive2://master0.repro> ... View more

Perform the following steps to access the Hive MetaStore database :-   SSH to the Data lake CM Node as 'cloudbreak' user. Run 'sudo -i' to gain root access. source activate_salt_env export PGPASSWORD=$(salt-call pillar.get postgres:hive:password 2>/dev/null| tail -n 1 | awk '{print $1}') HIVE_DB=$(salt-call pillar.get postgres:hive:database 2>/dev/null| tail -n 1 | awk '{print $1}') HIVE_DB_USER=$(salt-call pillar.get postgres:hive:user 2>/dev/null| tail -n 1 | awk '{print $1}') psql -U ${HIVE_DB_USER} -d ${HIVE_DB} e.g.   [root@xxxx-master0 ~]# source activate_salt_env (salt_3001.8) [root@xxxx-master0 ~]# export PGPASSWORD=$(salt-call pillar.get postgres:hive:password 2>/dev/null| tail -n 1 | awk '{print $1}') (salt_3001.8) [root@xxxx-master0 ~]# HIVE_DB=$(salt-call pillar.get postgres:hive:database 2>/dev/null| tail -n 1 | awk '{print $1}') (salt_3001.8) [root@xxxx-master0 ~]# HIVE_DB_USER=$(salt-call pillar.get postgres:hive:user 2>/dev/null| tail -n 1 | awk '{print $1}') (salt_3001.8) [root@xxxx-master0 ~]# psql -U ${HIVE_DB_USER} -d ${HIVE_DB} -c "SELECT version();" version ---------------------------------------------------------------------------------------------------------- PostgreSQL 14.11 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit (1 row)       ... View more