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.

Hive Action and Hive UDF in Oozie

Hive Action and Hive UDF in Oozie

New Contributor

Hi,

 

Have multiple xxx.hql (different) files which is depended on a hive common.hql which is setting the UDF temporary functions.

 

Now in Oozie workflow, the mutiple xxx.hql files are in parallel (fork)

 

Option I had,

1. Call the hive action for common.hql before the xxx.hql files hive action.

       [Does't work as the each hive action will be running in different container. Please correct me if understanding is wrong]

 

2. Set the CREATE TEMPORARY FUNCTION ....... command in a .hiverc file

      [This option is also not working.]

 

Please let me know if I have any other option to handle this.

 

Thanks and Regards

Suman Kumar

 

1 REPLY 1

Re: Hive Action and Hive UDF in Oozie

New Contributor

The issue was not with Oozie. It was hive which was not able to find the function.

 

Solution: 

In Hive 0.13 its handled, by creating the function in the metastore itself so it will be available to all the hive queries associated with the database.

 

Thanks 

Suman Kumar

Don't have an account?
Coming from Hortonworks? Activate your account here