question Re: Hive Shell (Client) is not running muliple servers at single time(able to login only single shell ) in Archives of Support Questions (Read Only)

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

subhash_parise3 — Wed, 17 Aug 2016 19:10:11 GMT

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 ?

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

shiremath — Wed, 17 Aug 2016 20:27:33 GMT

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.

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

subhash_parise3 — Wed, 17 Aug 2016 21:13:17 GMT

Hi @shiremath,

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

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

shiremath — Wed, 17 Aug 2016 21:13:56 GMT

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", "", "");

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

vshukla — Wed, 17 Aug 2016 23:31:24 GMT

@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,

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

subhash_parise3 — Thu, 18 Aug 2016 14:26:32 GMT

Hi @vshukla,

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