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.
