Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

SQL authorization in hive from Presto.

Highlighted

SQL authorization in hive from Presto.

Explorer

Enabled SQL authorization in hive and it's working fine for sql grant,revoke commands etc, but when i try to run sql grant,revoke commands etc from presto configured in same hadoop machine, it's failing with below error. And in hive logs, below log excerpt is seen.

Can anyone tell, is their any configuration needs to be done to successfully execute sql grant,revoke commands etc in presto.

	> SHOW GRANTS ON TABLE test01_u02;
Query 20170418_165132_00007_kqswj failed: Metastore Authorization api invocation for remote metastore is disabled in this configuration. Run commands via jdbc/odbc clients via HiveServer2 that is using embedded metastore.

2017-04-18 16:51:32,142 ERROR [pool-4-thread-146]: metastore.RetryingHMSHandler (RetryingHMSHandler.java:invokeInternal(193)) - MetaException(message:Metastore Authorization api invocation for remote metastore is disabled in this configuration. Run commands via jdbc/odbc clients via HiveServer2 that is using embedded metastore.) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.firePreEvent(HiveMetaStore.java:2017) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.get_role_grants_for_principal(HiveMetaStore.java:5660) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:138) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:97) at com.sun.proxy.$Proxy4.get_role_grants_for_principal(Unknown Source) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$get_role_grants_for_principal.getResult(ThriftHiveMetastore.java:11318) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Processor$get_role_grants_for_principal.getResult(ThriftHiveMetastore.java:11302) at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39) at org.apache.hadoop.hive.metastore.TUGIBasedProcessor.process(TUGIBasedProcessor.java:103) at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:285) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745)

Don't have an account?
Coming from Hortonworks? Activate your account here