question Re: Hive Transform Error in Archives of Support Questions (Read Only)

Hive Transform Error

khaslbeck — Sat, 28 Jan 2017 02:39:32 GMT

Is there another method or workaround that can replace the "transform" method. Or suggested usage to resolve the error below.

select transform(host, ip) using 'python parse_mro.py' as (host string, ip string) from table1;

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: Hive Transform Error

Arun- — Sat, 28 Jan 2017 03:17:17 GMT

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Transform#LanguageManualTransform-SQLStandardBasedAuthorizationDisallowsTRANSFORM

Ref:

https://issues.apache.org/jira/browse/HIVE-6415

Re: Hive Transform Error

icocio — Sat, 28 Jan 2017 03:51:51 GMT

It has bee disallowed for security reasons. There is an RMP in the pipeline for address this.

As a workaround, data should be transformed before reaching Hive.