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.
