Hi!
I logged into hue with a non-admin account and got a error when I use hive:
Bad status for request TOpenSessionReq(client_protocol=6, username=‘hue’, password=None, configuration={‘hive.server2.proxy.user’: ‘user_w’}): TOpenSessionResp(status=TStatus(statusCode=3, infoMessages=[’*org.apache.hive.service.cli.HiveSQLException:Failed to validate proxy privilege of admin for user_w:14:13’, ‘org.apache.hive.service.auth.HiveAuthFactory:verifyProxyAccess:HiveAuthFactory.java:347’, ‘org.apache.hive.service.cli.thrift.ThriftCLIService:getProxyUser:ThriftCLIService.java:802’, ‘org.apache.hive.service.cli.thrift.ThriftCLIService:getUserName:ThriftCLIService.java:382’, ‘org.apache.hive.service.cli.thrift.ThriftCLIService:getSessionHandle:ThriftCLIService.java:416’, ‘org.apache.hive.service.cli.thrift.ThriftCLIService:OpenSession:ThriftCLIService.java:313’, ‘org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession:getResult:TCLIService.java:1377’, ‘org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession:getResult:TCLIService.java:1362’, ‘org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39’, ‘org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39’, ‘org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56’, ‘org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:286’, ‘java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1149’, ‘java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:624’, ‘java.lang.Thread:run:Thread.java:748’, ‘*org.apache.hadoop.security.authorize.AuthorizationException:User: admin is not allowed to impersonate user_w:0:-1’], sqlState=‘08S01’, errorCode=0, errorMessage=‘Failed to validate proxy privilege of admin for user_w’), serverProtocolVersion=8, sessionHandle=None, configuration=None)
Here is a screenshot of how it was used
CDH version: 6.3.1
Hive:2.1.1+cdh6.3.2
sentry:2.1.0+cdh6.3.2
Please help