I am trying to run the following query: "revoke show_database to role test_role"
The result I get is: Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask (state=08S01,code=1) I checked hive.log and this is what I found: 2013-07-25 10:47:30,951 WARN metastore.RetryingMetaStoreClient (RetryingMetaStoreClient.java:invoke(95)) - MetaStoreClient lost connection. Attempting to reconnect. org.apache.thrift.TApplicationException: Internal error processing revoke_privileges at org.apache.thrift.TApplicationException.read(TApplicationException.java:108) at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:71) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_revoke_privileges(ThriftHiveMetastore.java:2536) at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.revoke_privileges(ThriftHiveMetastore.java:2523) at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.revoke_privileges(HiveMetaStoreClient.java:1204) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:74) at $Proxy9.revoke_privileges(Unknown Source) at org.apache.hadoop.hive.ql.metadata.Hive.revokePrivileges(Hive.java:1088) at org.apache.hadoop.hive.ql.exec.DDLTask.grantOrRevokePrivileges(DDLTask.java:791) at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:396) at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:138) at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57) at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1374) at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1160) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:973) at org.apache.hadoop.hive.ql.Driver.run(Driver.java:893) at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:259) at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:216) at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:412) at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:759) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:613) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:208) My metastore is a mysql server that runs on a remote server. Here are the namespaces and values for it's configuration: javax.jdo.option.ConnectionURL=jdbc:derby:;databaseName=metastore_db;create=true javax.jdo.option.ConnectionDriverName=org.apache.derby.jdbc.EmbeddedDriver javax.jdo.option.ConnectionUserName=APP javax.jdo.option.ConnectionPassword=mine datanucleus.autoCreateSchema=true hive.metastore.uris=thrift://hadoop3.localdomain:9083 Already I am not sure why the connectionURL points to a derby database. I am using the Cloudera Manager to manage my cluster, and it says that everything is configured correctly. That is going to be the first place I look. Brendan