question Re: How to produce Oozie production workflows in Support Questions

How to produce Oozie production workflows

jomach — Thu, 03 Aug 2017 12:48:17 GMT

I have a simple question. So I build a oozie Job with a hive action. Now I want to execute it on diferent hive databases. How can I do this ? Let's say development and production...

Re: How to produce Oozie production workflows

dineshc — Thu, 03 Aug 2017 13:06:26 GMT

Basically, your oozie workflow must pick a job properties from a path on the cluster. The job properties file will hold the details of hive server of that environment.

In your workflow you would be picking the values of database from the job property file. Thus your workflow will be generic and based on which environment you executing, it will pick up the job properties and consequently the required hive server.

Re: How to produce Oozie production workflows

jomach — Thu, 03 Aug 2017 13:29:22 GMT

I'm using hue, so that is Bering generated for me. At the moment I have on my hive sql file use someDatabase; which is like wrong, and I would like to get rid of it ... how to do it with hue ?

UPDATE:

So I actually find out the proper way to do it. Using hue params.

http://gethue.com/hadoop-tutorials-ii-2-execute-hive-queries-and/

Re: How to produce Oozie production workflows

dineshc — Thu, 03 Aug 2017 23:00:24 GMT

Cool! If you had mentioned the specifics in your question, you would have got help sooner 🙂