hadoop - 所需表缺失 : "DBS" in Catalog "" Schema ""

Question

我正在尝试在我的 Windows 机器上运行 Hive。但是，当我尝试从 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)

请帮忙。

Answer 1

您需要运行$HIVE_HOME\scripts\metastore\upgrade\mysql中提到的hive schema .sql脚本。在我的例子中，我使用 mysql 作为 hive 2.1.1 的基础数据库，所以我运行了 hive-schema-2.1.0.mysql.sql。您可以根据您的数据库进行尝试。