启动MySQL时missing,获取MissingTableException：在mysql上启动配置单元元数据存储时必需的表缺少​​VERSION...

Hive with mysql as the metadata store stopped working:

Caused by: 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"

Setting the autoCreateTables is not working either:

datanucleus.autoCreateTables

True

So how to fix this?

解决方案

Go to the $HIVE_HOME and run the initschema option on the schematool:

bin/schematool -dbType mysql -initSchema