All post related to BigData
How to resolve and troubleshoot Hive DB lock issue in production <b>Issue Description:</b> Job is failing or running very slow in production environment. <b>Error in logs: </b>Check the application log and…
PostgreSQL is a powerful, open-source relational database management system that undergoes regular updates to enhance performance, security, and features. Upgrading your PostgreSQL database from version 10 to version 13 is…
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…
Sometime we really struggle to get some simple things such as forming a JDBC URL so that we can establish a connection with different database. Today I am proving a…
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 my previous post I configured Auto-TLS in Cloudera Manager and CDH 6x. After enabling SSL, my development team faced this issue. Most of the developer use hue to connect…
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:…