PerfLogger Missing for Hive in CDH6

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: 2020-01-02 08:30:26,450 INFO org.apache.hadoop.hive.ql.log.PerfLogger: [HiveServer2-Background-Pool: Thread-898872]: <PERFLOG method=getSplits from=org.apache.hadoop.hive.ql.io.CombineHiveInputFormat> 2020-01-02 08:30:26,507 INFO org.apache.hadoop.hive.ql.log.PerfLogger: …

HiveServer2 Failed to Startup with NullPointerException

Recently I was dealing with an issue that HiveServer2 was not able to start up and keeps failing with NullPointerException error. See below full stacktrace: 2019-07-10 17:34:55,243 INFO org.apache.hive.service.server.HiveServer2: [main]: Exception caught when calling stop of HiveServer2 before retrying start java.lang.NullPointerException at org.apache.hive.service.server.HiveServer2.stop(HiveServer2.java:483) at org.apache.hive.service.server.HiveServer2.startHiveServer2(HiveServer2.java:571) … Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.hadoop.hive.ql.metadata.HiveException: …

HiveServer2 Failed to Start With “Table/View ‘DBS’ does not exist”

Recently I was dealing with an issue that after user upgraded CDH to 5.12.x, HiveServer2 was unable to start up. Examining the HiveServer2 log we noticed that for some reason HiveServer2 was try to access HiveMetaStore database and returned table does not exist error. See below full stacktrace: 2017-12-01 20:17:15,419 …