Hive之——启动问题及解决方案_at org.apache.hadoop.hive.ql.session.sessionstate.

作者：笔触狂放9 | 2024-06-14 19:53:55

踩

at org.apache.hadoop.hive.ql.session.sessionstate.start(sessionstate.java:50

问题1：

Caused by: javax.jdo.JDODataStoreException: Required table missing : "`VERSION`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"
NestedThrowables:
org.datanucleus.store.rdbms.exceptions.MissingTableException: Required table missing : "`VERSION`" in Catalog "" Schema "". DataNucleus requires this table to perform its persistence operations. Either your MetaData is incorrect, or you need to enable "datanucleus.autoCreateTables"
at org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:461)
at org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:732)
at org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:752)
at org.apache.hadoop.hive.metastore.ObjectStore.setMetaStoreSchemaVersion(ObjectStore.java:6664)

解决方法：
查看并跟踪hive的源码得出

if ((this.readOnlyDatastore) || (this.fixedDatastore))
{
this.autoCreateTables = false;
this.autoCreateColumns = false;
this.autoCreateConstraints = false;
}
else
{
boolean autoCreateSchema = conf.getBooleanProperty("datanucleus.autoCreateSchema");
if (autoCreateSchema)
{
this.autoCreateTables = true;
this.autoCreateColumns = true;
this.autoCreateConstraints = true;
}
else
{
this.autoCreateColumns = conf.getBooleanProperty("datanucleus.autoCreateColumns");
this.autoCreateTables = conf.getBooleanProperty("datanucleus.autoCreateTables");
this.autoCreateConstraints = conf.getBooleanProperty("datanucleus.autoCreateConstraints");
}
}

看来关键是 this.readOnlyDatastore和this.fixedDatastore 这2个字段而且autoCreateSchema 这个设置为true 就可以决定了其他的设置，所以其他设置在此都无效了。继续追踪org.datanucleus.store.AbstractStoreManager 发现了这2个字段的设置代码

this.readOnlyDatastore = conf.getBooleanProperty("datanucleus.readOnlyDatastore");
this.fixedDatastore = conf.getBooleanProperty("datanucleus.fixedDatastore");

修改的配置的内容如下

<property>
<name>datanucleus.readOnlyDatastore</name>
<value>false</value>
</property>
<property>
<name>datanucleus.fixedDatastore</name>
<value>false</value>
</property>
<property>
<name>datanucleus.autoCreateSchema</name>
<value>true</value>
</property>
<property>
<name>datanucleus.autoCreateTables</name>
<value>true</value>
</property>
<property>
<name>datanucleus.autoCreateColumns</name>
<value>true</value>

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/笔触狂放9/article/detail/719410