AnsweredAssumed Answered

Issue after configuring SQL Standard Based Authorization

Question asked by sonalitotade on May 19, 2016
Latest reply on May 19, 2016 by Hao Zhu



I am trying to Configure User Impersonation with Hive Authorization.

We are trying to implement “SQL Standard Based Authorization”. For this approach we refered

We are getting below errors after the setup.


- if i execute use database1; in hive it gives below message.

FAILED: RuntimeException SQL standards based authorization should not be enabled from hive cliInstead the use of storage based authorization in hive metastore is reccomended. Set to disable authz within cli


-if i try to execute select statement as shown it through the below error.



Please let me know if i am missing some configuration. I have restarted the drill bit on each node and the hive server2 after the configuration.


Thanks & Regards,