Toad uses JDBC only while connecting as a direct Hive Connection from Eclipse. In most other cases where a Hub is involved it uses Thrift.
On the other hand in the current release of Toad for Cloud there is no way to specify what hive user you want to connect as and hence it always connects as the User with which the hive server is running, and connects to the default database. What version of Toad for Cloud are you using? Thanks, Amit On Tue, Jan 31, 2012 at 10:59 AM, Sriram Krishnan <skrish...@netflix.com>wrote: > I was under the impression that Toad uses JDBC – and AFAIK there is no > way to authenticate users via JDBC using the HiveServer. > > FYI - https://issues.apache.org/jira/browse/HIVE-2539. > > BTW if anyone has a solution to this, I would be very interested to know > as well. > > Sriram > > From: Shantian Purkad <shantian_pur...@yahoo.com> > Reply-To: <user@hive.apache.org>, Shantian Purkad < > shantian_pur...@yahoo.com> > Date: Tue, 31 Jan 2012 10:20:04 -0800 > To: "user@hive.apache.org" <user@hive.apache.org> > Subject: Hive Security > > Hi, > > We are running Hive server and connecting to it through Toad. Everything > works fine. > > Now we want to enable authentication on the hive server. The hive server > indicates that we can specify user id password while connecting to it. > > Can someone please guide on how can we create and set users on hive > server? > > > Regards, > Shantian >
