How to produce Oozie production workflows

[#1]

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...

[#2]

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.

[#3 · Accepted solution]

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/

[#4]

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