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…
Use Case: Create a CertificateSigningRequest object with the name datalake with the contents of the datalake.csr filePlease note that an additional field called signerName should also be added when creating…
This shell script is designed to facilitate the backup of a PostgreSQL database. It allows users to easily configure and schedule daily backups, providing flexibility and control over the backup…
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…
Due to Covid-19 these days almost everyone is locked at home and avoiding moving out for the safety reason. I was discussing with few of my friends on this situation…