We just finished installing the 2 jar files and hql file in our Hive environment.
We ran the command/statement, hive -i catdm-masker-init.hql but was not successful.
it produced error: insufficient privileges to execute add (state=42000, code=0).
We googled for answers, and it was telling us to use JAVA function to add this jar, https://issues.apache.org/jira/browse/SENTRY-147
Note: Our cluster is having Kerberos and Sentry enabled and the Kerberos ticket was renewed before running the command.
I have uploaded the screenshot from our environment for your investigation. Let us know if you need more info.
The error is expected when using the Add Jar function and Sentry Security is enabled.
Component: CA Test Data Manager
No testing was done when implementing the solution for Hadoop while having the sentry component installed and configured.
So currently this is not supported.