Member since
01-08-2019
52
Posts
8
Kudos Received
2
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 4835 | 05-12-2019 06:21 PM |
09-10-2020
11:32 AM
In case ambari API doesn't help. You can use following SQL queries to abort hung/queued/pending operations directly from ambari database. 1) Stop Ambari-Server ambari-server stop 2) Take backup of ambari database before making any changes to ambari db 3) Check IN_PROGRESS, QUEUED and PENDING operations. ambari=> select task_id,role,role_command from host_role_command where status='IN_PROGRESS';
ambari=> select task_id,role,role_command from host_role_command where status='QUEUED' limit 100;
ambari=> select task_id,role,role_command from host_role_command where status='PENDING'; 4) Abort Operations ambari=> update host_role_command set status='ABORTED' where status='QUEUED';
ambari=> update host_role_command set status='ABORTED' where status='PENDING';
ambari=> update host_role_command set status='ABORTED' where status='IN_PROGRESS'; 5) Start ambari-server ambari-server start
... View more
07-31-2020
07:10 AM
For secured/kerberized cluster, we may need to push kdc admin credentials by creating a temp credential store before deleting Ranger Admin component ADD KDC CREDENTIALS: # curl -ivk -H "X-Requested-By: ambari" -u $AMBARI_USER:$AMBARI_PASSWD -X POST -d '{ "Credential" : { "principal" : "admin/admin@REALM", "key" : "hadoop", "type" : "temporary" } }' "$AMBARI_URL/api/v1/clusters/$CLUSTER_NAME/credentials/kdc.admin.credential" GET CREDENTIALS # curl -ivk -H "X-Requested-By: ambari" -u $AMBARI_USER:$AMBARI_PASSWD -X GET "$AMBARI_URL/api/v1/clusters/$CLUSTER_NAME/credentials/kdc.admin.credential"
... View more
05-12-2019
06:21 PM
1 Kudo
You must provide read and execute (r-x) permissions to others. Try this $ chmod 705 /home/maria_dev
$ sudo su hive
$ ls -l /home/maria_dev
... View more
03-25-2019
11:46 AM
Thanks Akhil S Naik 🙂
... View more
03-24-2019
06:41 PM
3 Kudos
IMPORTANT: DO NOT FORGET to backup your Ambari database before executing DELETE API calls. This is tested on Ambari version 2.6.x & 2.7.1. Kindly use these steps on your Test cluster first OR Contact Cloudera Support for more details. Step 1: Take a backup of your Ambari database # mkdir /var/tmp/postgres_backup
# pg_dump -U ambari ambari > /var/tmp/postgres_backup/$(date +"%Y%m%d%H%M%S")_ambari-bkp.sql Step 2: Install jq package (If not available) # rpm -qa | grep jq
# yum whatprovides jq
# yum install jq -y Step 3: Get All (AD/LDAP) Users & Groups # curl --insecure -u admin:admin -H 'X-Requested-By: ambari' -X GET http://$(hostname -f):8080/api/v1/users?Users/ldap_user=true | jq -r '.items[].Users.user_name' > ambari-ldap-users.txt
# curl --insecure -u admin:admin -H 'X-Requested-By: ambari' -X GET http://$(hostname -f):8080/api/v1/groups?Groups/ldap_group=true | jq -r '.items[].Groups.group_name' > ambari-ldap-groups.txt Step 4: Verify Users & Groups that needs to be deleted. If you want to keep some users/groups from the list, you can remove those entries from respective txt files. # cat ambari-ldap-users.txt
# cat ambari-ldap-groups.txt Step 5: Remove all AD Users # for my_ldap_user in $(cat ambari-ldap-users.txt)
do
curl --insecure -u admin:admin -H 'X-Requested-By: ambari' -X DELETE 'http://'$(hostname -f)':8080/api/v1/users/'$my_ldap_user
echo 'deleting : ' $my_ldap_user
done Step 6: Remove all AD Groups # for my_ldap_group in $(cat ambari-ldap-groups.txt)
do
curl --insecure -u admin:admin -H 'X-Requested-By: ambari' -X DELETE 'http://'$(hostname -f)':8080/api/v1/groups/'$my_ldap_group
echo 'deleting : ' $my_ldap_group
done
... View more
Labels:
11-23-2018
02:41 PM
When using Ambari managed INFRA-SOLR, we can also change TTL value from Ambari webUI and that would be an easy solution. ## Change Retention/TTL value of the ranger_audits collection in Ambari UI Ambari UI->Ranger->configs->advanced->advanced ranger solr configuration ->Max Retention Days ## Save & Restart required services
... View more