cdh安装hive出现Required table missing : “VERSION“ in Catalog ““ Schema ““. DataNucleus requires this tab_required table missing : "version" in catalog "" s

1> 刚开始尝试初始化cdh hive mysql数据库;

  cd [hive 安装目录] 
  bin/schematool -dbType mysql -initSchema --verbose
1
2

发现问题并没有解决;

2. 手动修改hive配置文件/etc/hive/conf/hive-site.xml

<configuration>
<property>
    <name>hive.metastore.db.type</name>
    <value>mysql</value>
    <description>元数据库类型指定为使用mysql</description>
</property>
<property>
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.jdbc.Driver</value>
    <description>指定mysql的驱动</description>
</property>
<property>
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>root</value>
    <description>指定元数据库用户</description>
</property>
<property>
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>root</value>
    <description>指定元数据库密码</description>
</property>
 <property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://[*************IP***********]:3306/hive?createDatabaseIfNotExist=true</value>
    <description>指定mysql连接串</description>
</property>
</configuration>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27