https://issues.apache.org/jira/browse/SENTRY-147
0: jdbc:hive2://......:10000/default> add jar /home/direp_hv_qa/satish/hive-udf-7.jar; Error: Insufficient privileges to execute add (state=42000,code=0) java.sql.SQLException: Insufficient privileges to execute add at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:167) at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:155) at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:210) at org.apache.hive.beeline.Commands.execute(Commands.java:736) at org.apache.hive.beeline.Commands.sql(Commands.java:657) at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:779) at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:646) at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:365) at org.apache.hive.beeline.BeeLine.main(BeeLine.java:348) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.hadoop.util.RunJar.main(RunJar.java:212) I'm receiving this exception even for users of admin role, Is this an issue with sentry. as all other load, select create and drop are working as per privileges set in the policy file. for "add jar" command its failing even for users of admin role.
Under Sentry you want an admin to inspect all Jars and then add them globally using
hive.aux.jars.path=/path/to/jar
ADD JAR Restricted unless
hive.server2.authorization.external.exec=true hive.security.authorization.enabled=false
What’s up everybody, here every one is sharing such familiarity, thus it’s pleasant to read this blog, and
I used to pay a quick visit this website everyday.