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>
      &lt;name&gt;javax.jdo.option.ConnectionURL</name&gt;
      <value&gt;jdbc:mysql://172.31.108.36:3306/hive</value&gt;
  </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>

之后进入/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.

代码007普通

打赏 收藏 海报 链接