Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 4ACCC102E3 for ; Thu, 25 Jul 2013 19:08:48 +0000 (UTC) Received: (qmail 43211 invoked by uid 500); 25 Jul 2013 19:08:45 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 43165 invoked by uid 500); 25 Jul 2013 19:08:44 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 43157 invoked by uid 99); 25 Jul 2013 19:08:44 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Jul 2013 19:08:44 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of bheussler@gmail.com designates 209.85.215.44 as permitted sender) Received: from [209.85.215.44] (HELO mail-la0-f44.google.com) (209.85.215.44) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Jul 2013 19:08:39 +0000 Received: by mail-la0-f44.google.com with SMTP id fo12so558279lab.31 for ; Thu, 25 Jul 2013 12:08:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to:content-type; bh=QMIEqxa2U9MRRJQNdXA86UCuo+mvnlXNVcr8QZqXapw=; b=W0cTXWpTxCrX+jHENxIuxQ7PtTZs9pLI0SbGuMSNfiSzE+K5PSNKW4KacFmiFVBAUG F8eyq2rh2p9JgEv6GAYkMZymEsSk4IfCtCTTNYnkCWr37zdoYnamjOlqvi7n4qclsTtw 1wkIaq9SpSRjZtHg5iDlA5hhB9t9aBiBi+nMnMHBC/zHnf/dtIr7dmlCfgnvar14KezR LVZxZI+5SZyFHzALVzBwXwTXYhcP/K/Z1wmqQX72fCJ8Hn/kmXddLXokxyDZUa7jiHPo zUD2AHHcYFfUOyQiTcmhrL25/U9vhxsOV8l/+KeWpLTPaJYZAhApK5NNC4WFkrG+0U3n AsLg== X-Received: by 10.112.167.136 with SMTP id zo8mr18789084lbb.33.1374779297784; Thu, 25 Jul 2013 12:08:17 -0700 (PDT) MIME-Version: 1.0 Received: by 10.112.159.131 with HTTP; Thu, 25 Jul 2013 12:07:57 -0700 (PDT) From: Brendan Heussler Date: Thu, 25 Jul 2013 15:07:57 -0400 Message-ID: Subject: Cannot Revoke Privileges To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a11c2a4a8b0680504e25abf96 X-Virus-Checked: Checked by ClamAV on apache.org --001a11c2a4a8b0680504e25abf96 Content-Type: text/plain; charset=ISO-8859-1 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 --001a11c2a4a8b0680504e25abf96 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
I am trying to run the following query: "revoke show_= database to role test_role"

The result I get is: Er= ror: Error while processing statement: FAILED: Execution Error, return code= 1 from org.apache.hadoop.hive.ql.exec.DDLTask (state=3D08S01,code=3D1)

I checked hive.log and this is what I found:

2013-07-25 10:47:30,951 WARN =A0metastore.RetryingMe= taStoreClient (RetryingMetaStoreClient.java:invoke(95)) - MetaStoreClient l= ost connection. Attempting to reconnect.
org.apache.thrift.TApplicationException: Internal error processing rev= oke_privileges
=A0 =A0 =A0 =A0 at org.apache.thrift.TApplicationE= xception.read(TApplicationException.java:108)
=A0 =A0 =A0 =A0 at = org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:71)
=A0 =A0 =A0 =A0 at org.apache.hadoop.hive.metastore.api.ThriftHiveMeta= store$Client.recv_revoke_privileges(ThriftHiveMetastore.java:2536)
=A0 =A0 =A0 =A0 at org.apache.hadoop.hive.metastore.api.ThriftHiveMetasto= re$Client.revoke_privileges(ThriftHiveMetastore.java:2523)
=A0 =A0 =A0 =A0 at org.apache.hadoop.hive.metastore.HiveMetaStoreClien= t.revoke_privileges(HiveMetaStoreClient.java:1204)
=A0 =A0 =A0 = =A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
=A0 =A0 =A0 =A0 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMeth= odAccessorImpl.java:39)
=A0 =A0 =A0 =A0 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Del= egatingMethodAccessorImpl.java:25)
=A0 =A0 =A0 =A0 at java.lang.r= eflect.Method.invoke(Method.java:597)
=A0 =A0 =A0 =A0 at org.apac= he.hadoop.hive.metastore.RetryingMetaStoreClient.invoke(RetryingMetaStoreCl= ient.java:74)
=A0 =A0 =A0 =A0 at $Proxy9.revoke_privileges(Unknown Source)
=A0 =A0 =A0 =A0 at org.apache.hadoop.hive.ql.metadata.Hive.revokePrivilege= s(Hive.java:1088)
=A0 =A0 =A0 =A0 at org.apache.hadoop.hive.ql.ex= ec.DDLTask.grantOrRevokePrivileges(DDLTask.java:791)
=A0 =A0 =A0 =A0 at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLT= ask.java:396)
=A0 =A0 =A0 =A0 at org.apache.hadoop.hive.ql.exec.T= ask.executeTask(Task.java:138)
=A0 =A0 =A0 =A0 at org.apache.hado= op.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57)
=A0 =A0 =A0 =A0 at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.= java:1374)
=A0 =A0 =A0 =A0 at org.apache.hadoop.hive.ql.Driver.ex= ecute(Driver.java:1160)
=A0 =A0 =A0 =A0 at org.apache.hadoop.hive= .ql.Driver.run(Driver.java:973)
=A0 =A0 =A0 =A0 at org.apache.hadoop.hive.ql.Driver.run(Driver.java:89= 3)
=A0 =A0 =A0 =A0 at org.apache.hadoop.hive.cli.CliDriver.proces= sLocalCmd(CliDriver.java:259)
=A0 =A0 =A0 =A0 at org.apache.hadoo= p.hive.cli.CliDriver.processCmd(CliDriver.java:216)
=A0 =A0 =A0 =A0 at org.apache.hadoop.hive.cli.CliDriver.processLine(Cl= iDriver.java:412)
=A0 =A0 =A0 =A0 at org.apache.hadoop.hive.cli.C= liDriver.run(CliDriver.java:759)
=A0 =A0 =A0 =A0 at org.apache.ha= doop.hive.cli.CliDriver.main(CliDriver.java:613)
=A0 =A0 =A0 =A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native= Method)
=A0 =A0 =A0 =A0 at sun.reflect.NativeMethodAccessorImpl.= invoke(NativeMethodAccessorImpl.java:39)
=A0 =A0 =A0 =A0 at sun.r= eflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav= a:25)
=A0 =A0 =A0 =A0 at java.lang.reflect.Method.invoke(Method.java:597)
=A0 =A0 =A0 =A0 at org.apache.hadoop.util.RunJar.main(RunJar.java:2= 08)

My metastore is a mysql server that runs on a = remote server. =A0Here are the namespaces and values for it's configura= tion:
javax.jdo.option.ConnectionURL=3Djdbc:derby:;databaseName=3Dmetastore_= db;create=3Dtrue
javax.jdo.option.ConnectionDriverName=3Dorg.= apache.derby.jdbc.EmbeddedDriver
javax.jdo.option.ConnectionU= serName=3DAPP
javax.jdo.option.ConnectionPassword=3Dmine
datanuc= leus.autoCreateSchema=3Dtrue
hive.metastore.uris=3Dthrift://h= adoop3.localdomain:9083

Already I am not sure = why the connectionURL points to a derby database. =A0I am using the Clouder= a Manager to manage my cluster, and it says that everything is configured c= orrectly. =A0That is going to be the first place I look.



Brendan
--001a11c2a4a8b0680504e25abf96--