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: =========================================== 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:remote_admin_pw| tail -n 1 | awk '{print $1}') HIVE_DB=$(salt-call pillar.get postgres:hive:database| tail -n 1 | awk '{print $1}') HIVE_DB_REMOTE_ADM=$(salt-call pillar.get postgres:hive:remote_admin| tail -n 1 | awk '{print $1}') HIVE_DB_REMOTE_PORT=$(salt-call pillar.get postgres:hive:remote_db_port| tail -n 1 | awk '{print $1}') HIVE_DB_REMOTE_URL=$(salt-call pillar.get postgres:hive:remote_db_url| tail -n 1 | awk '{print $1}') psql -h ${HIVE_DB_REMOTE_URL} -U ${HIVE_DB_REMOTE_ADM} -p ${HIVE_DB_REMOTE_PORT} -d ${HIVE_DB} ... View more