Apache Hive Performance Tuning
Also available as:

Configure Hive MetaStore event authorization

The default hive.metastore.event.db.notification.api.auth property configuration can prevent you from connecting to HiveServer Interactive process and using LLAP. You can change the property setting in hive-site.xml through Ambari.

  1. In Ambari, in Services > Hive > Configs > Advanced > Custom hive-site, add the following property key: hive.metastore.event.db.notification.api.auth
  2. Set the value of the property to false.