Recently I got a chance to work on this requirement where I need to create a clone of existing hive database. I need to create another database having same data…
After re-naming Hive database we faced one issue. This issue we faced on existing database. Issue Detail: -bash-4.2$ hdfs dfs -ls /user/hive/warehouse/demo.db ls: Permission denied: user=demo, access=READ_EXECUTE, inode="/user/hive/warehouse/demo.db":hive:hive:drwxrwx--x We check…
Recently I received a requirement to rename hive database, however current Apache hive release doesn't support this feature. In this Apache Hive Jira HIVE-4847, you can see this is a…
In this post I will explain how to add a separate Kafka Cluster in existing cluster.Prerequisite: 3 new hosts or EC2 instances.Install java Disable SelinuxRAM - 64 GB Java Heap - 4 GBCPU…
In this post let's see how we can enable TLS in Cloudera Manager and CDH.Requirement: Enable TLS encryption on existing Cloudera Manager and Cloudera cluster.Prerequisite: On all hosts I have…
After enabling Auto-TLS on cloudera cluster, Hue load balancer is not starting. We are getting below errors: Error Message: Stderr perl -pi -e 's#{{CLOUDERA_HTTPD_LOG_DIR}}#/mounts/edge/app/log/hue-httpd#' /var/run/cloudera-scm-agent/process/1295-hue-HUE_LOAD_BALANCER/httpd.conf /var/run/cloudera-scm-agent/process/1295-hue-HUE_LOAD_BALANCER/hue.conf /var/run/cloudera-scm-agent/process/1295-hue-HUE_LOAD_BALANCER/supervisor.conf Can't open /var/run/cloudera-scm-agent/process/1295-hue-HUE_LOAD_BALANCER/supervisor.conf:…
When I faced this issue on my cluster, I thought it can be resolved by just simple restart of cluster or restarting ResourceManager service, however I spent more than 8…
Today we will discuss about Clock Offset issue or NTP service is not synchronized to any remote server. Due to this error my services on the host is not starting.…
Today I have a requirement to implement Hive disaster recovery. I have to take a backup of Hive metadata and all hive DB's. Our development team is using different databases…
SummaryAfter changing 'Authentication Backend Order' to external, users cannot login. This guide explains how to revert back to default behaviour, authenticating through database first.SymptomsUsers cannot login to Cloudera ManagerConditionsCloudera Manager…