@ldylag No, it is not expected behavior. We expect the tables to be created in the 'public' schema under 'metastore' database. ... View more

@hadoopranger It seems like a transaction is in failed state. a drop database call probably did not complete successfully. Did we make config changes in postgres while Hive service was running? That could lead to data corruption.  I notice the following error: Cannot get Object result for param = 6 for column ""MV_CREATION_METADATA"."TXN_LIST"" : ERROR: current transaction is aborted, commands ignored until end of transaction block org.datanucleus.exceptions.NucleusDataStoreException: Cannot get Object result for param = 6 for column ""MV_CREATION_METADATA"."TXN_LIST"" : ERROR: current transaction is aborted, commands ignored until end of transaction block You may get the out of the following command and see which transaction is in idle but aborted state.   select * from pg_stat_activity; Then try to terminate the transaction or perform a ROLLBACK. Take a backup of the database before making these changes to be on the safer side. ... View more

@hadoopranger Make sure that [1] Hive namespace "hiveserver2" is correct, [2] You have a valid kerberos ticket in the client machine.  ... View more

@shofialau great! Now we can download mysql jdbc connector and place in the HMS node under the location /usr/share/java Detailed information can be found here - https://docs.cloudera.com/cdp-private-cloud-upgrade/latest/upgrade-hdp/topics/amb-install-mysql-jdbc.html#pnavId2 ... View more

@shofialau Let's not get confused with that JDBC driver mentioned in the doc. We can ignore that for now. We have two options relating to the metastore DB situation. Recover the password of the hive metastore DB user. Create a new database and user. I had shared the command to reset the DB user password(Option - 1) , or if you plan to create a new database(option -2), try the following commands: mysql> CREATE DATABASE hmsdb; mysql> CREATE USER 'hiveuser'@'metastorehost' IDENTIFIED BY 'mypassword'; mysql> REVOKE ALL PRIVILEGES, GRANT OPTION FROM 'hiveuser'@'metastorehost'; mysql> GRANT ALL PRIVILEGES ON hmsdb.* TO 'hiveuser'@'metastorehost'; mysql> FLUSH PRIVILEGES; mysql> quit; Replace the "metastorehost" with the Hive metastore node hostname.     ... View more

@MorganMcEvoy what is cluster-head.domain.com? Is this a load balancer or an individual HS2 node? Also, what's the client tool you are using?  Is it possible that it is not honoring the sslTrustStore parameter?  A workaround would be to import the root ca cert into the default java truststore in the client machine. ref: https://stackoverflow.com/questions/11700132/how-to-import-a-jks-certificate-in-java-trust-store ... View more

@MorganMcEvoy We have two different issues here: 1. ClassNotFoundException: com.ctc.wstx.io.InputBootstrapper This seems to be due to an incompatible version of the client, where which is using some hadoop libraries that are not compatible with your version of Hive. 2. SunCertPathBuilderException: unable to find valid certification path to requested target This basically means, you need to specify the truststore file(that contains the root cert of the CA) in the connection string. In case the application you are using is equivalent to beeline, I think adding the following to the connection string should work: ;ssl=true;sslTrustStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-global_truststore.jks;trustStorePassword=... SSL=1 might not work because it's is used with Cloudera and Apache JDBC driver. In case you have tried this already and it still fails, could you share the error message? ... View more