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,   can you post the error please? also cluld you please clarify the below : is your cluster having kerberos enabled? also did you enable hdfs extension for druid? whats the data type you are trying to read from hdfs ?    Best Regards  ... 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