Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Query with transform clause is disallowed in current configuration

Re: Query with transform clause is disallowed in current configuration

Here is the Apache JIRA that discusses this. It is unresolved at the moment. It discusses why TRANSFORM clause is a security risk and disabled with SQL Authorization in Hive. - Server wide Control over Transform Clause in Hive

Re: Query with transform clause is disallowed in current configuration

Mentor

@Raja Sekhar Chintalapati has this been resolved? Please accept best answer or provide your own solution.

Re: Query with transform clause is disallowed in current configuration

I followed the links provided, edited some of the security policies within Ranger, but I'm still not able to execute the Hive UDF. Here's my error msg:

Error while processing statement: FAILED: Hive Internal Error: org.apache.hadoop.hive.ql.security.authorization.plugin.HiveAccessControlException(Query with transform clause is disallowed in current configuration.)

Does anyone have additional tips/advice that would allow me to run a Hive "transform" UDF (that is written in python)?

This seems to run fine when I use a Spark to call the UDF, but I'd like to compare the results to Hive as well.

Thanks!

Highlighted

Re: Query with transform clause is disallowed in current configuration

New Contributor

Any update , its 2018. I am gettiing the same error,

Error: Error while processing statement: FAILED: Hive Internal Error: org.apache.hadoop.hive.ql.security.authorization.plugin.HiveAccessControlException(Query with transform clause is disallowed in current configuration.) (state=08S01,code=12)

Re: Query with transform clause is disallowed in current configuration

New Contributor

Any update on this?

I am getting same error as mentioned above even when I disabled Ranger