Hive authorization error

[Juwon Lee <Ju...@maxpointinteractive.com>]

Hello,

I am running into an exception when executing a simple query with authorization enabled. I have tried different authorization settings as well as metastore configuration, but without success. Also, the communication itself between Hive client and metastore DB (postgres) seems fine.

Any pointers?

Thanks,
J




hive> select * from bid2 limit 1;
11/07/11 16:33:25 DEBUG parse.VariableSubstitution: Substitution is on: select * from bid2 limit 1
11/07/11 16:33:25 INFO parse.ParseDriver: Parsing command: select * from bid2 limit 1
11/07/11 16:33:25 INFO parse.ParseDriver: Parse Completed

...

11/07/11 16:33:26 DEBUG ppr.PartitionPruner: Started pruning partiton
11/07/11 16:33:26 DEBUG ppr.PartitionPruner: dbname = default
11/07/11 16:33:26 DEBUG ppr.PartitionPruner: tabname = bid2
11/07/11 16:33:26 DEBUG ppr.PartitionPruner: prune Expression = null
FAILED: Hive Internal Error: org.apache.hadoop.hive.ql.metadata.HiveException(org.apache.thrift.TApplicationException: get_privilege_set failed: unknown result)
org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.thrift.TApplicationException: get_privilege_set failed: unknown result
                at org.apache.hadoop.hive.ql.metadata.Hive.get_privilege_set(Hive.java:1617)
                at org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider.authorizeUserPriv(DefaultHiveAuthorizationProvider.java:201)
                at org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider.authorizeUserAndDBPriv(DefaultHiveAuthorizationProvider.java:226)
                at org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider.authorizeUserDBAndTable(DefaultHiveAuthorizationProvider.java:259)
                at org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider.authorize(DefaultHiveAuthorizationProvider.java:159)
                at org.apache.hadoop.hive.ql.Driver.doAuthorization(Driver.java:521)
                at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:393)
                at org.apache.hadoop.hive.ql.Driver.run(Driver.java:736)
                at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164)
                at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241)
                at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456)
                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:186)
Caused by: org.apache.thrift.TApplicationException: get_privilege_set failed: unknown result
                at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_privilege_set(ThriftHiveMetastore.java:2414)
                at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_privilege_set(ThriftHiveMetastore.java:2379)
                at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.get_privilege_set(HiveMetaStoreClient.java:1042)
                at org.apache.hadoop.hive.ql.metadata.Hive.get_privilege_set(Hive.java:1615)
                ... 15 more

11/07/11 16:33:26 ERROR ql.Driver: FAILED: Hive Internal Error: org.apache.hadoop.hive.ql.metadata.HiveException(org.apache.thrift.TApplicationException: get_privilege_set failed: unknown result)
org.apache.hadoop.hive.ql.metadata.HiveException: org.apache.thrift.TApplicationException: get_privilege_set failed: unknown result
                at org.apache.hadoop.hive.ql.metadata.Hive.get_privilege_set(Hive.java:1617)
                at org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider.authorizeUserPriv(DefaultHiveAuthorizationProvider.java:201)
                at org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider.authorizeUserAndDBPriv(DefaultHiveAuthorizationProvider.java:226)
                at org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider.authorizeUserDBAndTable(DefaultHiveAuthorizationProvider.java:259)
                at org.apache.hadoop.hive.ql.security.authorization.DefaultHiveAuthorizationProvider.authorize(DefaultHiveAuthorizationProvider.java:159)
                at org.apache.hadoop.hive.ql.Driver.doAuthorization(Driver.java:521)
                at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:393)
                at org.apache.hadoop.hive.ql.Driver.run(Driver.java:736)
                at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:164)
                at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:241)
                at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:456)
                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:186)
Caused by: org.apache.thrift.TApplicationException: get_privilege_set failed: unknown result
                at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.recv_get_privilege_set(ThriftHiveMetastore.java:2414)
                at org.apache.hadoop.hive.metastore.api.ThriftHiveMetastore$Client.get_privilege_set(ThriftHiveMetastore.java:2379)
                at org.apache.hadoop.hive.metastore.HiveMetaStoreClient.get_privilege_set(HiveMetaStoreClient.java:1042)
                at org.apache.hadoop.hive.ql.metadata.Hive.get_privilege_set(Hive.java:1615)
                ... 15 more