Hi phil, It works ok, but it is a little flakey. Could you please let me know the kind of problems you faced? A few examples would help. I would want the ability to connect to the server from multiple clients and execute queries parallely. So, wanted to be aware of the pitfalls. Thanks, Suma
________________________________ From: Philip Tromans <philip.j.trom...@gmail.com> To: user@hive.apache.org Sent: Wednesday, March 28, 2012 11:26 AM Subject: Re: Hive server concurrency question I've used Hive in a multiple connections per server instance setup. It works ok, but it is a little flakey. I have some snapshot of trunk > 0.8.0 deployed. When I have some time, I'd like to help increase the test coverage for multithreaded clients. Phil. On 28 March 2012 19:19, Abhishek Pratap Singh <manu.i...@gmail.com> wrote: > AFAIK hive does not support concurrency however Multiple connection can be > made to HiveServer. > Hive or i should say Hadoop is write once and read multiple architecture. > Hive does not have a build in support for DELETE OR UPDATE. > The inherent architecture of these kind of solution works best when you > don't need Concurrency, Transaction or ACID properties. I have seen usecases > where wrapper to handle transaction is implemented but at the significant > cost of Performance. > > Regards, > Abhishek > > > On Wed, Mar 28, 2012 at 11:03 AM, sumadhur <sumadhur_i...@yahoo.com> wrote: >> >> Resending due to lack of response. >> From: sumadhur <sumadhur_i...@yahoo.com> >> To: "user@hive.apache.org" <user@hive.apache.org> >> Sent: Tuesday, March 27, 2012 2:14 AM >> Subject: Hive server concurrency question >> >> Hi, >> Does Hive server support multiple concurrent client connections? >> The following page says it does not support them. >> https://cwiki.apache.org/Hive/hiveodbc.html >> Hive Server is currently not thread safe >> The following page says that it was designed to support multiple >> connections. But there's no test coverage. >> https://cwiki.apache.org/Hive/hiveserver.html >> HiveServer is multithreaded and was designed to support multiple >> concurrent client connections. However, there is currently no test coverage >> for this scenario. If you want to play it safe we recommend running one >> HiveServer process per client connection. >> The following JIRA seems to imply that the hive server does support >> multiple concurrent connections. >> https://issues.apache.org/jira/browse/HIVE-77 >> What's the official stance on this? supported or not supported? >> Are there any known issues with hive server's handling of multiple >> concurrent client connections? >> Thanks, >> Sumadhur >> >> >
