@Shivakuk  Thank you for bringing this to our Community. Did you get to review the following Docs for respective role instances. Managing Role Instances https://docs.cloudera.com/cdp-private-cloud-base/7.1.9/managing-clusters/topics/cm-role-instances.html Yarn Resource Manager https://docs.cloudera.com/cdp-private-cloud-base/latest/yarn-high-availability/topics/yarn-resourcemanager-host-migration.html Moving HDFS Roles: https://docs.cloudera.com/documentation/enterprise/5-6-x/topics/admin_nn_migrate_roles.html#concept_w3h_m2l_2r Zookeeper https://docs.cloudera.com/documentation/enterprise/5-8-x/topics/cm_mc_zookeeper_service.html#ReplacingZkServerCM Spark on Yarn: Kindly make sure to take a backup of /etc/spark/conf folder and then proceed with the following: Deleting Role Instance: >Go to CM UI > Spark > Spark History Server Instance >Click Actions > Stop >Click Delete Adding/Configuring New Spark Instance: > Click on add role instances > Select on which host you want to install > Then start the role IMPORTANT: Please ensure to take backup of the working directories of concerned role instances, followed by re-deploying client configurations. Let us know how it goes. Cheers! V ... View more

Hi  @Shivakuk  As I test Sentry does not support DROP and DELETE privilege. However if you want to remove the DROP access from Admin user, then you have first remove ALL privileges and just provide  SELECT and INSERT privileges to the user NOTE: The DELETE, UPDATE, and UPSERT operations require the ALL privilege on the DB/ Table/ Column. ... View more

@Shivakuk, Did the response assist in resolving your query? If it did, kindly mark the relevant reply as the solution, as it will aid others in locating the answer more easily in the future.  ... View more

Hi @Shivakuk  It's a known behavior (bug) in CDH 6.3.4. The bug is resolved in CDP 7.x versions. Let me know if this helps.   Cheers! ... View more