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.
... View more
I have a partitioned table into which I am trying to insert data into a new partition. At the same time, I need to query a different partition on the same table. According to the documentation https://cwiki.apache.org/confluence/display/Hive/Locking I should be able to do it. But that is not what is happening in reality. I have two hive shells open, in one shell, I write data into T1 into a new partition called P14. In the second shell, I do a simple select query on partition P2. The select query waits until the insert query finishes and only then gives results where i deally it should give results immediately since it is a shared_read lock on partition P2 and I am doing a static partition insert. Also, when I do show locks on T1, I see an exclusive lock only the partition P14 and nothing else. Not even shared locks on other partitions. Am I missing something here?
... View more