hive 执行授权时出现异常(GRANT CREATE ON DATABASE default TO USER hive;)

set hive.files.umask.value=0002;

set hive.metastore.authorization.storage.checks=true;

 set hive.security.authorization.enabled=true;

set hive.security.authorization.createtable.owner.grants=ALL;

set hive.security.authorization.task.factory=

 org.apache.hadoop.hive.ql.parse.authorization.HiveAuthorizationTaskFactoryImpl;

0: jdbc:hive2://bd006:10000> set system:user.name;

+------------------------+--+

|          set     |

+------------------------+--+

| system:user.name=hive |

+------------------------+--+

1 row selected (0.01 seconds)

GRANT CREATE ON DATABASE default TO USER hive;

Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.

org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.thrift.transport.TTransportException (state=08S01,code=1)

详细错误信息:

[HiveServer2-Background-Pool: Thread-43]: Error running hive query:

org.apache.hive.service.cli.HiveSQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.thrift.transport.TTransportException

at org.apache.hive.service.cli.operation.Operation.toSQLException(Operation.java:400)

at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:238)

at org.apache.hive.service.cli.operation.SQLOperation.access$300(SQLOperation.java:89)

at org.apache.hive.service.cli.operation.SQLOperation$3$1.run(SQLOperation.java:301)

at java.security.AccessController.doPrivileged(Native Method)

at javax.security.auth.Subject.doAs(Subject.java:422)

at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1917)

at org.apache.hive.service.cli.operation.SQLOperation$3.run(SQLOperation.java:314)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

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)

Caused by: org.apache.hadoop.hive.ql.security.authorization.plugin.HiveAuthzPluginException: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.thrift.transport.TTransportException

at org.apache.hadoop.hive.ql.security.authorization.plugin.HiveV1Authorizer.grantPrivileges(HiveV1Authorizer.java:77)

at org.apache.hadoop.hive.ql.exec.DDLTask.grantOrRevokePrivileges(DDLTask.java:675)

at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:465)

at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:214)

at org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:99)

at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:2041)

at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:1748)

at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1501)

at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1285)

at org.apache.hadoop.hive.ql.Driver.run(Driver.java:1280)

at org.apache.hive.service.cli.operation.SQLOperation.runQuery(SQLOperation.java:236)

... 11 more

Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.thrift.transport.TTransportException

at org.apache.hadoop.hive.ql.metadata.Hive.grantPrivileges(Hive.java:1331)

at org.apache.hadoop.hive.ql.security.authorization.plugin.HiveV1Authorizer.grantOrRevokePrivs(HiveV1Authorizer.java:103)

at org.apache.hadoop.hive.ql.security.authorization.plugin.HiveV1Authorizer.grantPrivileges(HiveV1Authorizer.java:75)

... 21 more

Caused by: org.apache.thrift.transport.TTransportException

at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132)

at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86)

at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:429)

at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:318)

at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:219)

at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:77)

at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_grant_revoke_privileges(ThriftHiveMetastore.java:3800)

at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.grant_revoke_privileges(ThriftHiveMetastore.java:3787)

at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.grant_privileges(HiveMetaStoreClient.java:1833)

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.RetryingMetaStoreClient.invoke(RetryingMetaStoreClient.java:105)

at com.sun.proxy.$Proxy19.grant_privileges(Unknown Source)

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.HiveMetaStoreClient$SynchronizedHandler.invoke(HiveMetaStoreClient.java:2084)

at com.sun.proxy.$Proxy19.grant_privileges(Unknown Source)

at org.apache.hadoop.hive.ql.metadata.Hive.grantPrivileges(Hive.java:1329)

... 23 more