I have a bunch of questions about Hive LLAP and its queues.
1. I have to run two types of queries on LLAP and want to set two different queues for each of them. I tried setting it up but Yarn resource manager failed to start saying it failed to initiate the queues.
2. How can I connect from beeline to Hive/LLAP on a specific queue?
3. How many concurrent users can LLAP have? I have a cluster with 8 data nodes and we currently set LLAP queue capacity to 90%. It is not letting me have more than 4 concurrent users. (Well I can have more than 4 but it is using 100% of the cluster which is bad. I thought it divides the resources equally among all sessions)
Thanks in advance.
No you can't, currently at least. LLAP supports only one queue instance as far as I know.
You may do a workaround by starting multiple LLAP sessions instead of sub-queuing. Here's the JIRA https://issues.apache.org/jira/browse/AMBARI-18917. I couldn't find a doc to do that, you may find with more search.
LLAP is very different from HS2, and the concept of sessions doesn't translate directly.
You can control concurrency only by setting the property "hive.server2.tez.sessions.per.default.queue"=desired sessions in hive-interactive-site.xml (if you're doing via ambari) or hive2/hive-site.xml (on disk) or modify directly via config section in hive.
Also num_llap_nodes in hive-interactive-env controls the number of nodes to run LLAP daemons, set this to 8 if you want it to run on all nodes or 7 (recommended).
It's also important to set optimal values of llap_queque %, llap_heap_size, cache memory, llap_num_executors, number of io threads for better performance. See below links for more info:-
I think you can't, I'm not really sure though.
If you can't, I think your solution would be to start multiple LLAP instances (probably you would get a different url for both) and hence submit jobs. Or you could increase sessions in your llap queue hive.server2.tez.sessions.per.default.queue This would give you some concurrency.
This is a useful link https://issues.apache.org/jira/browse/AMBARI-16720