Try restarting the Hive Server 2 with the setting "hive.server2.enable.doAs=true" in hive-site.xml. This will make HiveServer2 perform actions as connecting user.
On Tue, Aug 5, 2014 at 5:16 PM, sai chaitanya tirumerla <tirume...@gmail.com > wrote: > Hi, > > I am trying to connect using my username and password from JDBC/ODBC > tools ( sql workbench/squirrel etc..) to hiveserver2 but always the > connection is made with the default user who starts hiveserver2 but not the > actual user who is getting connected. > > I could see it is inheriting all the properties( hive-site.xml ) of the > default user but not the properties of the connected user. Is there any way > that we can change this connecting to hiveserver2. > > > Thanks, > Sai >