@sipocootap2  Unfortunately, you cannot disallow snapshots in a snapshottable directory that already has snapshots! Yes, you will have to list and delete the snapshot even if it contains subdirs you only pass the root snapshot in the hdfs dfs -deleteSnapshot command. If you had an  $ hdfs dfs -ls /app/tomtest/.snapshot Found 2 items drwxr-xr-x - tom developer 0 2021-07-26 23:14 /app/tomtest/.snapshot/sipo/work/john drwxr-xr-x - tom developer 0 2021-07-26 23:14 /app/tomtest/.snapshot/tap2/work//peter You would simply delete the snapshots like  $ hdfs dfs -deleteSnapshot /app/tomtest/ sipo $ hdfs dfs -deleteSnapshot /app/tomtest/ tap2   ... View more

@USMAN_HAIDER  There is this step below did you perform that? Kerberos must be specified as the security mechanism for Hadoop infrastructure, starting with the HDFS service. Enable Cloudera Manager Server security for the cluster on an HDFS service. After you do so, the Cloudera Manager Server automatically enables Hadoop security on the MapReduce and YARN services associated with that HDFS service. In the Cloudera Manager Admin Console: Select Clusters > HDFS-n. 1.Click the Configuration tab. 2.Select HDFS-n for the Scope filter. 3.Select Security for the Category filter. 4.Scroll (or search) to find the Hadoop Secure Authentication property. 5.Click the Kerberos button to select Kerberos: Please revert             ... View more

@SheltonThank you so much ... View more

@mike_bronson7    Are you using the default capacity schedule settings? No queues/leafs created?  Is what you shared the current seeting? ... View more

@tarekabouzeid91 wrote: I assume you are using Capacity scheduler not fair scheduler. that's why queues wont take available resources from other queues, you can read more regarding that here Comparison of Fair Scheduler with Capacity Scheduler | CDP Public Cloud (cloudera.com) .  Yes I am using Capacity scheduler. yarn.resourcemanager.scheduler.class = org.apache.hadoop.yarn.server.resourcemanager.scheduler.capacity.CapacityScheduler ... View more

Hi @srinivasp    I believe you are missing SELECT and LIST privilege for the table in ranger for the user. Can you try to list the tables using Hive user from beeline and check whether you are seeing the same problem? ... View more

Hi @dgiri_india1989    Could you please share more details for this issue about how you are able to fix this.  We are also facing similar issue with Ranger KMS service. RangerKMS Principal is created in AD KDC, Also Keytab creation is success according to Ambari Server log, but it's not distributed to RangerKMS service hosted node. Due to this service is not starting up.    Thank you.  ... View more

@SparkNewbie  Bingo you are using the derby DB, which is only recommended for testing.   There are three modes for Hive Metastore deployment: Embedded Metastore Local Metastore Remote Metastore In Hive by default, metastore service runs in the same JVM as the Hive service. It uses embedded derby database stored on the local file system in this mode. Thus both metastore service and hive service runs in the same JVM by using embedded Derby Database. But, this mode also has its limitation that, as only one embedded Derby database can access the database files on disk at any one time, so only one Hive session could be open at a time. 21/07/07 23:07:56 INFO MetaStoreDirectSql: Using direct SQL, underlying DB is DERBY Derby is an embedded relational database in Java program and used for online transaction processing and has a 3.5 MB disk-space footprint. Depending on your software HDP or Cloudera ensure the hive DB is plugged to an external Mysql database For CDH using Mysql  For HDP using mysql  Check your current hive UI backend metadata databases !! After installing MySQL then you should toggle hive config to point to the external Mysql database .. Once done your commands and the refresh should succeed Please let me know if you need help Happy hadooping   ... View more

Thank you for your participation in Cloudera Community. I'm happy to see you resolved your issue. Please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. ... View more