Hi, I have the same issue. I ran "hive --service metastore -verbose".  It says "start hive metastore on port 9083". I can see the listening on 9083 via netstate. I can enter hive env. but if I ran "hive> show databases;" It throws " hive exception....Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient".  The Mysql database setting is correct. I can access the database via Workbench using the credentials as in the hive-site.xml. Please could you guide? Thanks! ... View more

Hi Moh-AJ   yes u right its all there i already config and try start and from error log it said TT cant open connection to RM server ip, i already open all connection. i will post my conf and error log here so other hadoop can help me.       ... View more

  Access logs from RM UI : Using RM UI > Applications > click on your failed application > application master > then goto the logs at the end of screen . - it's good idea to check your container logs which may shows whats happening .     - if you are using hive-tez kinda of issues appear if missing class , once the container start loading these class for tez , because count(*), insert queries will use yarn to submit new application ; so it's good check classpath for tez , and check if you have correct tez.tar.gz on the HDFS which contains all needed jars . ... View more

- so first thing you have to prepare your metastore using schematool as : ./schematool -initSchema -dbType mysql -verbose   - Use the command below to start up HMS and check the debug logs under hiveCLI : su -l hive -c "/<replace>/bin/hive --service metastore -hiveconf hive.log.file=debug_hms.log -hiveconf hive.log.dir=/var/log/hive/HMSdebug -hiveconf hive.root.logger=DEBUG,DRFA > /var/log/hive/hiveMS.out 2>/var/log/hive/hiveMS.log &" *make sure to replace it with correct hive path.   - if possible please share your hive config .   ... View more

Hi @Nil_kharat  Still not resolved the issue. You may need to check the HS2 logs and application logs to figure the slowness. And one more thing how can we track the job that are running by user's. 1. Go to RM UI > Running/finished/killed > check the User column 2. CM > YARN > Applications > Based upon the user you can search over here. If you are happy with the response mark it as Accepts as Solution   ... View more