Hi,   How to configure the retention period for CDP INFRA SOLR? Couldn't find the options suggested in this post in Cloudera Manager.   Thanks, Megh ... View more

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

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

@Geoffrey Shelton Okot My intention is to use "su hive", not "su - hive". Below is the resource showing the difference. https://www.tecmint.com/difference-between-su-and-su-commands-in-linux/ Thanks. ... View more

Thanks Akhil S Naik 🙂 ... View more