Hive Transform Error

[#1]

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)

[#2]

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

Ref:

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

[#3 · Accepted solution]

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.