Hive启动报错(个人遇到问题&解决方法)

hive执行sql报错

FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient

 解决办法：1、初始化mysql数据库

                   2、注释配置文件$HIVE_HOME/conf/hive-site.xml

<!--
 <property>
    <name>hive.metastore.uris</name>
    <value>thrift://master:9083</value>
    <description>Thrift URI for the remote metastore. Used by metastore client to connect to remote metastore.</description>
  </property>
-->

   初始化数据库

./schematool -dbType mysql -initSchema