Apache Hive Performance Tuning
Also available as:

Configure the HiveServer heap size

Generally, configuring HiveServer heap memory according to the recommendations in this topic ensures proper LLAP functioning. If HiveServer heap memory is set too low, HiveServer Interactive keeps going down.

  1. In Ambari, go to Services > Hive > Config.
  2. In Optimization, adjust the slider to set the heap size.
    For 1 to 20 concurrent executing queries, set to 6 GB heap size; 21 to 40 concurrent executing queries: Set to 12 GB heap size.