Hive Shell (Client) is not running muliple servers at single time(able to login only single shell )

[#1]

Hi Community Team,

can anyone help me to configure hive client to login multiple sessions at single time(using multiple servers). after i exit the one session able to open next session. i have added a new queue in yarn queue manager and added that que in in hive config and also changed the Number of threads used by Compactor = 2 in hive config. can any one suggest how can i do this ?

[#2]

Hi Subhash,

Using hive shell or beeline instance we will be able to connect only one session at a time, but we can run multiple instances of beeline which can connect to different servers.

[#3]

Hi @shiremath,

is any other way to run multiple sessions parllelly to run queries in hive ??

[#4 · Accepted solution]

we can do this by writing client https://cwiki.apache.org/confluence/display/Hive/HiveClient to have multiple connections and use those connections to run queries.

Connection con = DriverManager.getConnection("jdbc:hive://localhost:10000/default", "", "");

[#5]

@subhash parise This question seems to be about Hive but Spark is also tagged on it.

Can you please explain the scenario that you are trying to enable?

Thanks,

[#6]

Hi @vshukla,

i haven't noticed spark tagging. this question is related to enable multiple hive shell sessions in multiple server at single time.