You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by "Sunderlin, Mark" <ma...@teamaol.com> on 2011/03/18 21:24:51 UTC
End User Clients for Hive?
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
Re: End User Clients for Hive?
Posted by Carl Steinbach <ca...@cloudera.com>.
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 <
florin.diaconeasa@gmail.com> 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 <ki...@mustardgrain.com>
> 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.
>
>
Re: End User Clients for Hive?
Posted by Florin Diaconeasa <fl...@gmail.com>.
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 <ki...@mustardgrain.com> 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.
Re: End User Clients for Hive?
Posted by Edward Capriolo <ed...@gmail.com>.
On Fri, Mar 18, 2011 at 6:44 PM, Kirk True <ki...@mustardgrain.com> 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.
Re: End User Clients for Hive?
Posted by Kirk True <ki...@mustardgrain.com>.
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
>
>
>