异常:进入Hive View提示user home check fail 详细日志:Service 'userhome' check failed: java.io.FileNotFoundException: File does not exist: /user/admin
处理方式:
查看目录结构 hdfs dfs -ls /user 发现没有admin目录,自己创建一个
su hdfs
hdfs dfs -mkdir /user/admin
hdfs dfs -chown admin:hdfs /user/admin
异常:查询SQL提示:S020 Data storage error 详细日志为:
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'ambari.DS_JOBIMPL_11' doesn't exist
登录到mysql 进入到ambari数据库 use ambari;
查看show tables; 并没有此表,重新创建一个:
CREATE TABLE DS_JOBIMPL_11 ( DS_id VARCHAR(255) NOT NULL,
DS_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, PRIMARY KEY (ds_id));
异常: 查询sql提示:
Caused by: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): Unauthorized connection for super-user: root from IP 192.168.32.134
at org.apache.hadoop.hdfs.web.JsonUtil.toRemoteException(JsonUtil.java:119)
at org.apache.hadoop.hdfs.web.WebHdfsFileSystem.validateResponse(WebHdfsFileSystem.java:480)
修改配置:
Custom core-site
hadoop.proxyuser.hive.hosts = *
然后重启hdfs