[HIVE-6674] "show grant on all" throws NPE

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.13.0
• Assignee: Navis Ryu
• Reporter: Thejas Nair
• Created: 14/Mar/14 21:12
• Updated: 23/Oct/15 09:35
• Resolved: 27/Mar/14 00:13

Description

"show grant on all" is supposed to show all the grants in the system on all the objects. But it fails with NPE with both SQL standard auth, and legacy auth.

Caused by: java.lang.NullPointerException
        at org.apache.hadoop.hive.metastore.ObjectStore.listPrincipalAllDBGrant(ObjectStore.java:4206)
        at org.apache.hadoop.hive.metastore.ObjectStore.listPrincipalDBGrantsAll(ObjectStore.java:4169)
        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.RawStoreProxy.invoke(RawStoreProxy.java:108)
        at com.sun.proxy.$Proxy6.listPrincipalDBGrantsAll(Unknown Source)
        at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.list_db_privileges(HiveMetaStore.java:4295)
        ... 36 more

Issue Links

• is related to: HIVE-6673 sql std auth - show grant statement for all principals throws NPE