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…
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…
Last week one of my development team member came to me with below error which he faced while executing a hive query on hue. Error while processing statement: FAILED: Execution…
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…