HIVE安装时出现的问题

 

  在对HIVE安装时出现了 MetaException(message:Version information not found in metastore.)

                               以及MetaException(message:Required table missing : "`DBS`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.schema.autoCreateTables")的问题

  解决这两个问题首先要打开位于/hive/conf/hive-site.xml这个文件

  第一个的原因是初次启动时并没有设置hive.metastore.schema.verification，所以将property写上去就可以了

  第二个问题可以通过设置datanucleus.schema.autoCreateAll的值解决

  启动时可能存在MySQL的ssl问题，如果存在的话，请在jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true这句话后面加上&useSSL=false（xml中&需要用&表示）

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
  <property>
    <name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&amp;useSSL=false</value>
    <description>JDBC connect string for a JDBC metastore</description>
  </property>
  <property>
    <name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
    <description>Driver class name for a JDBC metastore</description>
  </property>
  <property>
<name>javax.jdo.option.ConnectionUserName</name>
    <value>hive</value>
    <description>username to use against metastore database</description>
  </property>
  <property>
<name>javax.jdo.option.ConnectionPassword</name>
    <value>hive</value>
    <description>password to use against metastore database</description>
  </property><property>
   <name>hive.metastore.schema.verification</name>
   <value>false</value>
    <description>
    Enforce metastore schema version consistency.
    True: Verify that version information stored in metastore matches with one from Hive jars.  Also disable automatic
          schema migration attempt. Users are required to manully migrate schema after Hive upgrade which ensures
          proper metastore schema migration. (Default)
    False: Warn if the version information stored in metastore doesn't match with one from in Hive jars.
    </description>
 </property>
<property>  
    <name>datanucleus.schema.autoCreateAll</name>  
    <value>true</value>  
    <description>creates necessary schema on a startup if one doesn't exist. set this to false, after creating it once</description>  
 </property>  
</configuration>