我正在windows计算机上运行配置单元。但是当我试图从c:\hadoop-2.7.1\hive-2.1.0\bin>hive运行命令时，它会给出以下错误。
Required table missing : "DBS" in Catalog "" Schema "".
DataNucleus requires this table to perform its persistence operations.
Either your MetaData is incorrect, or you need to enable "datanucleus.schema.autoCreateTables"
org.datanucleus.store.rdbms.exceptions.MissingTableException: Required table missing : "DBS" in Catalog "" Schema "".
DataNucleus requires this table to perform its persistence operations.
Either your MetaData is incorrect, or you need to enable "datanucleus.schema.autoCreateTables"
at org.datanucleus.store.rdbms.table.AbstractTable.exists(AbstractTable.java:606)请帮忙。
1条答案
按热度按时间9rygscc11#
您需要运行$hive\u home\scripts\metastore\upgrade\mysql中提到的hive schema.sql脚本。在我的例子中，我使用mysql作为hive2.1.1的底层数据库，所以我运行了hive-schema-2.1.0.mysql.sql。您可以根据您的数据库进行尝试。