Cannot Revoke Privileges

[Brendan Heussler <bh...@gmail.com>]

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