HiveMetaException: Failed to get schema version, Cause:Table 'metastore.VERSION' doesn't exist_org.apache.hadoop.hive.metastore.hivemetaexception

CDH6.1安装问题解决

系统: Centos7.5, 数据库:mysql5.7.24, 虚拟机:VMware Workstation12 pro(12.5.5)

在安装集群的最后阶段,hive验证出现问题
org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version, Cause:Table 'metastore.VERSION' doesn't exist
出现这个问题是因为/opt/cloudera/cm/schema/scm_prepare_database.sh mysql metastore hive_user创建的库与系统冲突
解决方法: 删除数据库metastore,该数据库的创建由当前集群系统的schematool工具创建,但是要修改配置文件
/opt/cloudera/parcels/CDH-6.1.0-1.cdh6.1.0.p0.770702/lib/hive/conf/hive-site.xml
添加如下内容:

  <property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://192.168.44.144:3306/metastore?createDatabaseIfNotExist=true&amp;useSSL=false</value>     这里是是创建数据库metastore,同时&要转义&amp;
    <!-- <value>jdbc:derby:;databaseName=metastore_db;create=true</value>-->
    <description>
      JDBC connect string for a JDBC metastor