org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version, Cause:Table ‘hive.

CDH报错：org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version, Cause:Table ‘hive.VERSION’ doesn’t exist
​

需要初始化一下数据，进入到hive.site.xml配置文件中，添加如下内容

<property>
      <name>javax.jdo.option.ConnectionURL</name>
      <value>jdbc:mysql://172.31.108.36:3306/hive</value>
  </property>
  <property>
      <name>javax.jdo.option.ConnectionDriverName</name>
      <value>com.mysql.jdbc.Driver</value>
  </property>
  <property>
      <name>javax.jdo.option.ConnectionUserName</name>
      <value>root</value>
  </property>
  <property>
      <name>javax.jdo.option.ConnectionPassword</name>
      <value>root</value>
  </property>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

之后进入/opt/cloudera/parcels/CDH-6.3.2-1.cdh6.3.2.p0.1605554/lib/hive/bin目录下执行
./schematool -dbType mysql -initSchema
参考报错：org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.