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.

  1. In Ambari, select Services > Hive > Configs > Settings.
  2. In Interactive Query, set Enable Interactive Query to Yes:
  3. In Select HiveServer Interactive Host, select the server to host HiveServer Interactive.
    For example, accept the default highlighted server, which is typically a good choice.