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 <[email protected]<mailto:[email protected]>> Reply-To: <[email protected]<mailto:[email protected]>>, Shantian Purkad <[email protected]<mailto:[email protected]>> Date: Tue, 31 Jan 2012 10:20:04 -0800 To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>> 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
