Hi Team, This is Prsanna. I'm new to CDP and trying to create a CDP Trail base cluster for testing purposes, but while creating it I'm facing an error in the Hive Service. Please suggest a possible solution. Please refer to the screenshot and log file. Log file: jar:/opt/cloudera/parcels/CDH-7.1.7-1.cdh7.1.7.p0.15945976/lib/hadoop-mapreduce/ranger-raz-intg-2.1.0.7.1.7.0-551.jar:/usr/share/java/mysql-connector-java.jar:/opt/cloudera/cm/lib/postgresql-42.2.14.jre7.jar:/usr/share/java/oracle-connector-java.jar + [[ -n '' ]] + [[ create_metastore_tables == webhcat ]] + [[ create_metastore_tables == hiveserver2 ]] + [[ create_metastore_tables == updatelocation ]] + [[ create_metastore_tables == create_metastore_tables ]] + [[ -z /opt/cloudera/cm ]] + JDBC_JARS_CLASSPATH='/opt/cloudera/cm/lib/*:/usr/share/java/mysql-connector-java.jar:/opt/cloudera/cm/lib/postgresql-42.2.14.jre7.jar:/usr/share/java/oracle-connector-java.jar' + [[ create_metastore_tables == create_metastore_tables ]] + '[' 7 -ge 5 ']' + skip_if_tables_exist metastore_db_py.properties + '[' -z metastore_db_py.properties ']' + DB_INFO_FILENAME=metastore_db_py.properties + JDBC_JARS=/usr/share/java/mysql-connector-java.jar:/opt/cloudera/cm/lib/postgresql-42.2.14.jre7.jar:/usr/share/java/oracle-connector-java.jar + [[ -z /opt/cloudera/cm ]] + JDBC_JARS_CLASSPATH='/opt/cloudera/cm/lib/*:/usr/share/java/mysql-connector-java.jar:/opt/cloudera/cm/lib/postgresql-42.2.14.jre7.jar:/usr/share/java/oracle-connector-java.jar' ++ /usr/java/jdk1.8.0_232-cloudera/bin/java -Djava.net.preferIPv4Stack=true -cp '/opt/cloudera/cm/lib/*:/usr/share/java/mysql-connector-java.jar:/opt/cloudera/cm/lib/postgresql-42.2.14.jre7.jar:/usr/share/java/oracle-connector-java.jar' com.cloudera.cmf.service.hive.HiveMetastoreDbUtil /var/run/cloudera-scm-agent/process/1546335447-hive-metastore-create-tables/metastore_db_py.properties unused --printTableCount Exception in thread "main" java.lang.RuntimeException: org.postgresql.util.PSQLException: The connection attempt failed. at com.cloudera.cmf.service.hive.HiveMetastoreDbUtil.countTables(HiveMetastoreDbUtil.java:203) at com.cloudera.cmf.service.hive.HiveMetastoreDbUtil.printTableCount(HiveMetastoreDbUtil.java:284) at com.cloudera.cmf.service.hive.HiveMetastoreDbUtil.main(HiveMetastoreDbUtil.java:354) Caused by: org.postgresql.util.PSQLException: The connection attempt failed. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:297) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:217) at org.postgresql.Driver.makeConnection(Driver.java:458) at org.postgresql.Driver.connect(Driver.java:260) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at com.cloudera.enterprise.dbutil.SqlRunner.open(SqlRunner.java:193) at com.cloudera.enterprise.dbutil.SqlRunner.getDatabaseName(SqlRunner.java:264) at com.cloudera.cmf.service.hive.HiveMetastoreDbUtil.countTables(HiveMetastoreDbUtil.java:197) ... 2 more Caused by: java.net.SocketTimeoutException: connect timed out at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:607) at org.postgresql.core.PGStream.<init>(PGStream.java:81) at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:93) at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:197) ... 11 more + NUM_TABLES='[ main] SqlRunner ERROR Error connecting to db with user '\''hive'\'' and jdbcUrl '\''jdbc:postgresql://gateway:7432/hive'\''' + [[ 1 -ne 0 ]] + echo 'Failed to count existing tables.' + exit 1   ... View more

Hi team, is it possible to add an SSL Certificate to the Cloudera Community  Express CDH-6.2.1 Version? please guide me through the steps to update SSL Cerificate. Thanks Prasanna ... View more

I'm using Cloudera login credentials for downloading from the link but getting 403 Forbidden (varnish) the provided credentials were incorrect https://username:password@archive.cloudera.com/p/cm6/6.2.1.4505/redhat7/yum/ what are the username and password here? please tell me Thanks Prasanna ... View more

Hi, team please help me to install druid on CDH-6.2.1, I'm unable to add the parcels and jar file in csd location, I didn't find the druid downloading csd file. please help me with this.     Thanks Prasanna ... View more

Hi can you help me on this, the cluster is running fine in two days back, and now I'm getting  "This host has been out of contact with the Cloudera Manager Server for a concerning amount of time. This host is not in contact with the Host Monitor" getting all services are in critical.  after some time it shows good in health, then again it turns critical. I check the agent service status in that node. it's running and below it showing  OSError: [Errno 2] No such file or directory: '/run/user/984' actually /run/user/984 directory is still exist. Time synchronization is working., I'm not getting any idea about why it happens. Thanks  Prasanna ... View more