Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

ADD JAR command from beeline - nsufficient privileges to execute ADD

avatar
New Contributor

Hi, I am trying to execute ADD JAR command from beeline and am ending up with error as below. Error: Insufficient privileges to execute ADD (state=42000,code=0) I am able to get it added with out issues using the hive terminal. Note 1. Kerberos is enabled. 2. have multiple roles like admin_role, hive_role etc… could you please give your thoughts to resolve. Thanks. 🙂

1 REPLY 1

avatar
Contributor

Greetings,

 

This describes the issue you are having. It is a combination of beeline and Sentry security causing this.

 

http://wp.huangshiyang.com/add-jar-command-throws-insufficient-privileges-to-execute-add-exception-e...

 

https://issues.apache.org/jira/browse/SENTRY-147

 

The work around we have found was to use the deprecated hive command line (not beeline) which still appears to work with Kerberos and CDH 5.8.2 (latest released).

 

The "supported" solution is in the first link I put up, basically all users must give the JAR files for Hive UDFs to an admin that can put them in a location that is accessible by all users and whitelisted from Sentry security.