Recently I discovered that the performance logs were missing from both HiveServer2 and HiveMetaStore server logs. This makes troubleshooting performance related issue very hard. The log message that I am expecting is something like below: HiveServer2 Log: Above log tells me that the getSplit operation took 57 milli-seconds to complete. …
Recently I was dealing with an issues that HiveMetaStore failed to start in a Cloudera Manager managed environment. It failed with below errors: This problem is very common if you have the following misconfiguration in your cluster: 1. Wrong version of Java being used. For a list of supported version …
This article explains the possible causes when HiveMetastore server (HMS) takes a long time to start up (more than 10 minutes). Every time when Hive is restarted through Cloudera Manager (CM), it takes more than 10 minutes for Hive services to become green and users to be able to use beeline CLI. …
This article explains the possible causes when HMS server takes a long time to start up (more than 10 minutes) The symptom: every time when Hive is restarted through CM, it will take more than 10 minutes for Hive services to become green and users to be able to use …
Sympton: After upgrading Cloudera Manager (CM) from CDH5.3 to CDH5.4, the requirement was to also upgrade the Hive Metastore Database Schema: However, it failed with the following message: It is not immediately apparent what needs to be done. Initially you might think that some of the indexes contained too many …
My new Snowflake Blog is now live. I will not be updating this blog anymore but will continue with new contents in the Snowflake world!