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