FAILED: Error in metadata: javax.jdo.JDODataStoreException: Error executing JDOQL query "SELECT 'org.apache.hadoop.hive.metastore.model.MDatabase' AS NUCLEUS_TYPE,THIS."DESC",THIS.DB_LOCATION_URI,THIS."NAME",THIS.DB_ID FROM DBS THIS WHERE THIS."NAME" = ?" :
Table/View 'DBS' does not exist..
NestedThrowables:
java.sql.SQLSyntaxErrorException: Table/View 'DBS' does not exist.
NestedThrowables:
java.sql.SQLSyntaxErrorException: Table/View 'DBS' does not exist.
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask
由错误可知,DBS不存在
由于HIve默认使用的是Derby,在配置安装时,hive-site.xml是从hive-default.xml.template中复制过来的
所以新添加的配置信息
javax.jdo.option.ConnectionURL
javax.jdo.optionConnectionDriverName
javax.jdo.optionConnectionUserNaem
javax.jdo.optionConnectionPassword
这几个信息在文件中有配置,只不过配置的是Derby
我们把默认配置删除
自定义配置信息就可以生效
Hive系统会加载hive-default.xml和hive-site.xml两个配置文件
当hive-site.xml与hive-default.xml文件中不一致时,以hive-site.xml为准
所以把hive-site.xml中不需要的参数删除,只保留新配置的文件信息