Apache Hive Performance Tuning
Also available as:

Enable interactive query

You need to enable interactive query to take advantage of low-latency analytical processing (LLAP) of Hive queries. When you enable interactive query, you select a host for HiveServer Interactive.

The Interactive Query control displays a range of values for default Maximum Total Concurrent Queries based on the number of nodes that you select for LLAP processing and the number of CPUs in the Hive LLAP cluster. The Ambari wizard typically calculates appropriate values for LLAP properties in Interactive Query, so accept the defaults or change the values to suit your environment.

When you enable Interactive Query, the Run as end user and Hive user security settings have no effect. These controls affect batch-processing mode.

  1. In Ambari, select Services > Hive > Configs > Settings.
  2. In Interactive Query, set Enable Interactive Query to Yes:
  3. In Select HiveServer Interactive Host, accept the default server to host HiveServer Interactive, or from the drop-down, select a different host.
    If you do not want to set up multiple HiveServer Interactives for high availability, skip the next set of steps, and proceed to configuring the llap queue.