异常:进入Hive View提示user home check fail 详细日志:Service 'userhome' check failed: java.io.FileNotFoundException: File does not exist: /user/admin
处理方式:
查看目录结构 hdfs dfs -ls /user 发现没有admin目录,自己创建一个
hdfs dfs -mkdir /user/admin
hdfs dfs -chown admin:hdfs /user/admin
异常:查询SQL提示:S020 Data storage error 详细日志为:Table 'ambari.DS_JOBIMPL_16' doesn't exist (Hive View)
Table 'ambari.DS_JOBIMPL_9' doesn't exist (Hive View 2.0)
登录到mysql 进入到ambari数据库 use ambari;
查看show tables; 并没有此表,重新创建一个:
CREATE TABLE DS_JOBIMPL_16 ( DS_id VARCHAR(255) NOT NULL, S_applicationId TEXT, DS_confFile TEXT, DS_dagId TEXT, DS_dagName TEXT, DS_dataBase TEXT, DS_dateSubmitted BIGINT, DS_duration BIGINT, DS_forcedContent TEXT, DS_globalSettings TEXT, DS_guid TEXT, DS_hiveQueryId TEXT, DS_logFile TEXT, DS_owner TEXT, DS_queryFile TEXT, DS_queryId TEXT, DS_referrer TEXT, DS_sessionTag TEXT, DS_sqlState TEXT, DS_status TEXT, DS_statusDir TEXT, DS_statusMessage TEXT, DS_title TEXT, DS_applicationId TEXT, PRIMARY KEY (ds_id));
异常: 查询sql提示:Unauthorized connection for super-user: root from IP 192.168.126.103 详细日志: org.apache.hadoop.security.authorize.AuthorizationException: Unauthorized connection for super-user: root from IP 192.168.126.103
修改配置:
Custom core-site
hadoop.proxyuser.hive.hosts = *