Apache Hive Performance Tuning
Also available as:

Configure a custom LLAP queue

You can create and customize a queue for interactive querying instead of accepting the default llap queue during LLAP setup in Ambari.

You have not set up the default llap queue in Ambari.
  1. In Ambari, access the capacity scheduler:
    • Select YARN > Configs > Advanced, and in Filter enter yarn.scheduler.capacity.root.
    • On the command line of the node where YARN is installed, go to the YARN /conf file, and open the capacity-scheduler.xml file.
  2. Define the custom LLAP queue, specifying a name and other properties, such as capacity and usage limits.
    For example:
  3. From the Ambari dashboard, select ADMIN > Manage Ambari > Views.
  4. Click the URL for the view named AUTO_CS_INSTANCE, which is the capacity scheduler view.
  5. In the YARN Queue Manager, click Add Queue.
  6. Enter the queue path, which is the name of the custom queue myllap hive1.
  7. In Ambari, select Services > Hive > Configs > Settings.
  8. In Interactive Query, set Enable Interactive Query to Yes:
  9. In Select HiveServer Interactive Host, select the server to host HiveServer Interactive.
    For example, select the default highlighted server, which is typically a good choice.
  10. In Interactive Query Queue, select the custom YARN queue for LLAP myllap:
    This setting dedicates all the LLAP daemons and YARN ApplicationMasters of the system to the single, specified queue.