You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Guy Doulberg <Gu...@conduit.com> on 2011/02/15 17:48:51 UTC
TOAD for hive
Hey,
I started using Toad for querying hive, looks promising
http://nosql.mypopescu.com/post/2913202510/hive-and-hbase-in-toad-for-cloud-demo
http://toadforcloud.com/index.jspa
enjoy
Thanks,
Guy
RE: TOAD for hive
Posted by Peter Hall <Pe...@quest.com>.
Hi Otis,
If you have any details regarding crashes we’d be most interested in collecting more information about what lead to the crash. Toad for Cloud forums http://toadforcloud.com/forumindex.jspa?categoryID=735 would be the best place to post any such information.
The credentials supplied when mapping a data source define the permissions allowed on that data source. While some of the NoSQL databases do not have a strong security model, this can be used to restrict users connected to ODBC data sources. There could still be a concern when mapping data sources in a data hub that is shared with other users. This type of user access will be addressed in an upcoming release of Toad for Cloud Databases.
If you have any questions or feedback regarding Toad for Cloud that you would like to share please post on the forums at http://toadforcloud.com/forumindex.jspa?categoryID=735
Regards,
Peter Hall
Quest Software
________________________________
From: Otis Gospodnetic [otis_gospodnetic@yahoo.com]
Sent: Saturday, 26 February 2011 9:00
To: user@hive.apache.org
Subject: Re: TOAD for hive
Hi,
I've had a quick look at Toad for Cloud the other day, too.
* One complaint I heard (but have not verified) is that it crashed. I don't have the details. Anyone seen any crashes?
* The other "complaint" I heard is that just like it allows easy querying, it allows the person using it easy data modification/deletion. This can be a problem when you have a bunch of people who need to run ad-hoc reports, but should absolutely not make any changes to data. Perhaps there is a way to make data mods/deletion impossible in Toad for Cloud?
Thanks,
Otis
----
Sematext :: http://sematext.com/ :: Solr - Lucene - Hadoop
Hadoop ecosystem search :: http://search-hadoop.com/
From: Guy Doulberg <Gu...@conduit.com>
To: "user@hive.apache.org" <us...@hive.apache.org>
Sent: Tue, February 15, 2011 11:48:51 AM
Subject: TOAD for hive
Hey,
I started using Toad for querying hive, looks promising
http://nosql.mypopescu.com/post/2913202510/hive-and-hbase-in-toad-for-cloud-demo
http://toadforcloud.com/index.jspa
enjoy
Thanks,
Guy
Re: TOAD for hive
Posted by Otis Gospodnetic <ot...@yahoo.com>.
Hi,
I've had a quick look at Toad for Cloud the other day, too.
* One complaint I heard (but have not verified) is that it crashed. I don't
have the details. Anyone seen any crashes?
* The other "complaint" I heard is that just like it allows easy querying, it
allows the person using it easy data modification/deletion. This can be a
problem when you have a bunch of people who need to run ad-hoc reports, but
should absolutely not make any changes to data. Perhaps there is a way to make
data mods/deletion impossible in Toad for Cloud?
Thanks,
Otis
----
Sematext :: http://sematext.com/ :: Solr - Lucene - Hadoop
Hadoop ecosystem search :: http://search-hadoop.com/
>
>From: Guy Doulberg <Gu...@conduit.com>
>To: "user@hive.apache.org" <us...@hive.apache.org>
>Sent: Tue, February 15, 2011 11:48:51 AM
>Subject: TOAD for hive
>
>
>Hey,
>
>I started using Toad for querying hive, looks promising
>
>http://nosql.mypopescu.com/post/2913202510/hive-and-hbase-in-toad-for-cloud-demo
>http://toadforcloud.com/index.jspa
>
>enjoy
>
>Thanks,
>Guy
>
RE: TOAD for hive
Posted by Guy Doulberg <Gu...@conduit.com>.
Thanks,
That did the trick
-----Original Message-----
From: Peter Hall [mailto:Peter.Hall@quest.com]
Sent: Monday, February 21, 2011 11:45 PM
To: user@hive.apache.org
Subject: RE: TOAD for hive
The way to add jars has changed. In your hive-site.xml add something like:
<property>
<name>hive.aux.jars.path</name>
<value>file:/path/to/your/jar</value>
</property>
Cheers,
Peter Hall
Quest Software
________________________________________
From: Guy Doulberg [Guy.Doulberg@conduit.com]
Sent: Tuesday, 22 February 2011 0:56
To: user@hive.apache.org
Subject: RE: TOAD for hive
I think I found a lead,
The following code is taken from the hiveserver.sh
if [ $minor_ver -lt 20 ]; then
exec $HADOOP jar $AUX_JARS_CMD_LINE $JAR $CLASS $HIVE_PORT "$@"
else
# hadoop 20 or newer - skip the aux_jars option and hiveconf
exec $HADOOP jar $JAR $CLASS $HIVE_PORT "$@"
fi
I am using hadoop 0.20.2,
So the else clause is being executed,
Do you know how to fix this?
Is there a JIRA for this or even a patch?
-----Original Message-----
From: Guy Doulberg [mailto:Guy.Doulberg@conduit.com]
Sent: Sunday, February 20, 2011 4:23 PM
To: user@hive.apache.org
Subject: RE: TOAD for hive
I ran into some problems with this maybe you can help me out.
I have aux jars, in them I have a custom writable object,
I put my jars in auxlib, using hive interactive mode it works perfectly, but
Using TOAD for hive, the jobs fail, looking in the jobtracker I see that my custom writable class cannot be found..
Any ideas?
-----Original Message-----
From: Peter Hall [mailto:Peter.Hall@quest.com]
Sent: Wednesday, February 16, 2011 2:29 AM
To: user@hive.apache.org
Subject: RE: TOAD for hive
It certainly does.
There's a server component available as a windows installer and an rpm and 2 clients, a windows standalone client and an eclipse plugin.
Cheers,
Peter Hall
Quest Software
________________________________________
From: Cam Bazz [cambazz@gmail.com]
Sent: Wednesday, 16 February 2011 10:50
To: user@hive.apache.org
Subject: Re: TOAD for hive
thats good news, but does it run in linux?
On Tue, Feb 15, 2011 at 6:48 PM, Guy Doulberg <Gu...@conduit.com> wrote:
> Hey,
>
>
>
> I started using Toad for querying hive, looks promising
>
>
>
> http://nosql.mypopescu.com/post/2913202510/hive-and-hbase-in-toad-for-cloud-demo
>
> http://toadforcloud.com/index.jspa
>
>
>
> enjoy
>
>
>
> Thanks,
>
> Guy
>
>
RE: TOAD for hive
Posted by Peter Hall <Pe...@quest.com>.
The way to add jars has changed. In your hive-site.xml add something like:
<property>
<name>hive.aux.jars.path</name>
<value>file:/path/to/your/jar</value>
</property>
Cheers,
Peter Hall
Quest Software
________________________________________
From: Guy Doulberg [Guy.Doulberg@conduit.com]
Sent: Tuesday, 22 February 2011 0:56
To: user@hive.apache.org
Subject: RE: TOAD for hive
I think I found a lead,
The following code is taken from the hiveserver.sh
if [ $minor_ver -lt 20 ]; then
exec $HADOOP jar $AUX_JARS_CMD_LINE $JAR $CLASS $HIVE_PORT "$@"
else
# hadoop 20 or newer - skip the aux_jars option and hiveconf
exec $HADOOP jar $JAR $CLASS $HIVE_PORT "$@"
fi
I am using hadoop 0.20.2,
So the else clause is being executed,
Do you know how to fix this?
Is there a JIRA for this or even a patch?
-----Original Message-----
From: Guy Doulberg [mailto:Guy.Doulberg@conduit.com]
Sent: Sunday, February 20, 2011 4:23 PM
To: user@hive.apache.org
Subject: RE: TOAD for hive
I ran into some problems with this maybe you can help me out.
I have aux jars, in them I have a custom writable object,
I put my jars in auxlib, using hive interactive mode it works perfectly, but
Using TOAD for hive, the jobs fail, looking in the jobtracker I see that my custom writable class cannot be found..
Any ideas?
-----Original Message-----
From: Peter Hall [mailto:Peter.Hall@quest.com]
Sent: Wednesday, February 16, 2011 2:29 AM
To: user@hive.apache.org
Subject: RE: TOAD for hive
It certainly does.
There's a server component available as a windows installer and an rpm and 2 clients, a windows standalone client and an eclipse plugin.
Cheers,
Peter Hall
Quest Software
________________________________________
From: Cam Bazz [cambazz@gmail.com]
Sent: Wednesday, 16 February 2011 10:50
To: user@hive.apache.org
Subject: Re: TOAD for hive
thats good news, but does it run in linux?
On Tue, Feb 15, 2011 at 6:48 PM, Guy Doulberg <Gu...@conduit.com> wrote:
> Hey,
>
>
>
> I started using Toad for querying hive, looks promising
>
>
>
> http://nosql.mypopescu.com/post/2913202510/hive-and-hbase-in-toad-for-cloud-demo
>
> http://toadforcloud.com/index.jspa
>
>
>
> enjoy
>
>
>
> Thanks,
>
> Guy
>
>
RE: TOAD for hive
Posted by Guy Doulberg <Gu...@conduit.com>.
I think I found a lead,
The following code is taken from the hiveserver.sh
if [ $minor_ver -lt 20 ]; then
exec $HADOOP jar $AUX_JARS_CMD_LINE $JAR $CLASS $HIVE_PORT "$@"
else
# hadoop 20 or newer - skip the aux_jars option and hiveconf
exec $HADOOP jar $JAR $CLASS $HIVE_PORT "$@"
fi
I am using hadoop 0.20.2,
So the else clause is being executed,
Do you know how to fix this?
Is there a JIRA for this or even a patch?
-----Original Message-----
From: Guy Doulberg [mailto:Guy.Doulberg@conduit.com]
Sent: Sunday, February 20, 2011 4:23 PM
To: user@hive.apache.org
Subject: RE: TOAD for hive
I ran into some problems with this maybe you can help me out.
I have aux jars, in them I have a custom writable object,
I put my jars in auxlib, using hive interactive mode it works perfectly, but
Using TOAD for hive, the jobs fail, looking in the jobtracker I see that my custom writable class cannot be found..
Any ideas?
-----Original Message-----
From: Peter Hall [mailto:Peter.Hall@quest.com]
Sent: Wednesday, February 16, 2011 2:29 AM
To: user@hive.apache.org
Subject: RE: TOAD for hive
It certainly does.
There's a server component available as a windows installer and an rpm and 2 clients, a windows standalone client and an eclipse plugin.
Cheers,
Peter Hall
Quest Software
________________________________________
From: Cam Bazz [cambazz@gmail.com]
Sent: Wednesday, 16 February 2011 10:50
To: user@hive.apache.org
Subject: Re: TOAD for hive
thats good news, but does it run in linux?
On Tue, Feb 15, 2011 at 6:48 PM, Guy Doulberg <Gu...@conduit.com> wrote:
> Hey,
>
>
>
> I started using Toad for querying hive, looks promising
>
>
>
> http://nosql.mypopescu.com/post/2913202510/hive-and-hbase-in-toad-for-cloud-demo
>
> http://toadforcloud.com/index.jspa
>
>
>
> enjoy
>
>
>
> Thanks,
>
> Guy
>
>
RE: TOAD for hive
Posted by Guy Doulberg <Gu...@conduit.com>.
I ran into some problems with this maybe you can help me out.
I have aux jars, in them I have a custom writable object,
I put my jars in auxlib, using hive interactive mode it works perfectly, but
Using TOAD for hive, the jobs fail, looking in the jobtracker I see that my custom writable class cannot be found..
Any ideas?
-----Original Message-----
From: Peter Hall [mailto:Peter.Hall@quest.com]
Sent: Wednesday, February 16, 2011 2:29 AM
To: user@hive.apache.org
Subject: RE: TOAD for hive
It certainly does.
There's a server component available as a windows installer and an rpm and 2 clients, a windows standalone client and an eclipse plugin.
Cheers,
Peter Hall
Quest Software
________________________________________
From: Cam Bazz [cambazz@gmail.com]
Sent: Wednesday, 16 February 2011 10:50
To: user@hive.apache.org
Subject: Re: TOAD for hive
thats good news, but does it run in linux?
On Tue, Feb 15, 2011 at 6:48 PM, Guy Doulberg <Gu...@conduit.com> wrote:
> Hey,
>
>
>
> I started using Toad for querying hive, looks promising
>
>
>
> http://nosql.mypopescu.com/post/2913202510/hive-and-hbase-in-toad-for-cloud-demo
>
> http://toadforcloud.com/index.jspa
>
>
>
> enjoy
>
>
>
> Thanks,
>
> Guy
>
>
RE: TOAD for hive
Posted by Peter Hall <Pe...@quest.com>.
It certainly does.
There's a server component available as a windows installer and an rpm and 2 clients, a windows standalone client and an eclipse plugin.
Cheers,
Peter Hall
Quest Software
________________________________________
From: Cam Bazz [cambazz@gmail.com]
Sent: Wednesday, 16 February 2011 10:50
To: user@hive.apache.org
Subject: Re: TOAD for hive
thats good news, but does it run in linux?
On Tue, Feb 15, 2011 at 6:48 PM, Guy Doulberg <Gu...@conduit.com> wrote:
> Hey,
>
>
>
> I started using Toad for querying hive, looks promising
>
>
>
> http://nosql.mypopescu.com/post/2913202510/hive-and-hbase-in-toad-for-cloud-demo
>
> http://toadforcloud.com/index.jspa
>
>
>
> enjoy
>
>
>
> Thanks,
>
> Guy
>
>
Re: TOAD for hive
Posted by Cam Bazz <ca...@gmail.com>.
thats good news, but does it run in linux?
On Tue, Feb 15, 2011 at 6:48 PM, Guy Doulberg <Gu...@conduit.com> wrote:
> Hey,
>
>
>
> I started using Toad for querying hive, looks promising
>
>
>
> http://nosql.mypopescu.com/post/2913202510/hive-and-hbase-in-toad-for-cloud-demo
>
> http://toadforcloud.com/index.jspa
>
>
>
> enjoy
>
>
>
> Thanks,
>
> Guy
>
>