因为需要重装impala,先将impala删除,但是误操作,使得ambari-server启动不了,正确的顺序是:
curl -u admin:admin -H "X-Requested-By: ambari" -X DELETE http://58.198.176.92:8093/api/v1/clusters/hadoop/services/IMPALA
再接着删除 ambari-server/resources中的IMPALA文件夹
于是查到需要在数据库中删除数据,我使用的是postgres-embedded,于是需要用ambari登入
任务一:使用ambari登录postgres,
root用户
vim /var/lib/pgsql/data/pg_hba.conf
sudo su
加入
local all ambari,mapred md5
host all ambari,mapred 0.0.0.0/0 md5
host all ambari,mapred ::/0 md5
重启pg
/etc/init.d/postgresql restart
登录
psql -U ambari -d ambari
pwd: bigdata
删除数据IMPALA
delete from servicedesiredstate where service_name like '%IMPALA%';
delete from hostcomponentstate where component_name like '%IMPALA%';
delete from hostcomponentdesiredstate where component_name like '%IMPALA%';
delete from servicecomponentdesiredstate where component_name like '%IMPALA%';
delete from clusterservices where service_name like 'IMPALA';
启动服务
sudo service ambari-server restart
reference:
http://www.bubuko.com/infodetail-186279.html
http://www.thinksaas.cn/topics/0/497/497575.html