Hi Florin, I am not aware of any plans to support prepared statements in Hive. The performance issues that motivate the use of prepared statements with other DBs aren't really applicable to Hive, so there has not been much interest in building the infrastructure that this feature requires.
Thanks. Carl On Thu, Mar 24, 2011 at 12:56 PM, Florin Diaconeasa < [email protected]> wrote: > Hi, > > Sorry to burst in like this, but are there any plans for supporting > prepared statements? Because it's a shame not having them. While true, > they're not generally used (i presume), the Pentaho Report Designer could > use them for example :) > > -------------------------------------------- > Florin Diaconeasa > > On Mar 19, 2011, at 5:28 PM, Edward Capriolo wrote: > > > On Fri, Mar 18, 2011 at 6:44 PM, Kirk True <[email protected]> > wrote: > >> Hi Mark, > >> > >> Karmasphere Analyst[1] is a powerful, yet easy-to-use UI for Hive. > >> > >> Disclaimer: Karmasphere is one of my clients and I work on Analyst. > >> > >> Thanks, > >> Kirk > >> > >> [1] > http://www.karmasphere.com/Products-Information/karmasphere-analyst.html > >> > >> On 3/18/11 1:24 PM, Sunderlin, Mark wrote: > >>> > >>> As we prepare Hive for use by general business analysts and other > >>> end-users, I am wondering what the community's experience is with > clients > >>> for end users? > >>> > >>> My user base currently is using tools such as WinSQL and Toad on their > >>> Windows machines to access current systems, such as MySQL, Oracle and > >>> Netezza. Ideally, they be able to use their current clients to connect > to > >>> and interact with Hive. > >>> > >>> Is there a ODBC-JDBC connector for Windows that works better with Hive > >>> than any other? > >>> > >>> Alternatively, what do your end users use as a Hive Client? > >>> > >>> --- > >>> Mark E. Sunderlin > >>> Solutions Architect |AOL Data Warehouse > >>> P: 703-256-6935 | C: 540-327-6222 > >>> AIM: MESunderlin > >>> 22000 AOL Way | Dulles, VA | 20166 > >>> > >>> > >>> > >> > > > > A lot of work has gone into the JDBC driver. This allows you to use > > micro-strategy or other JDBC tools. The Web interface exists and > > clodera's web interfaces exist if you are using their distro. > > > > Bringing hive to the "end-user" is still difficult IMHO. Based on > > cluster size 20-30 nodes you may only have the capacity to run 4-6 > > jobs at once. Users have to understand that your current cluster needs > > to do for production, and be trained to know their Ad-Hoc jobs could > > be very impacting. > >
