FAQ
Thank!! Is there a python API available for this? I presume it should be.
On Apr 17, 2014 6:15 PM, "Vikram Srivastava" wrote:

Once you've configured Oozie in CM, you should run Create Database command
from Oozie service in CM UI instead of running it from command line.

On Thu, Apr 17, 2014 at 6:11 PM, Vikram Bajaj wrote:

Hi,

While setting up the oozie service with mysql database, oozie does not
create schema automatically in CDH5 as opposed to CDH4.

The document says "The Oozie database tool works in 2 modes: it can
create the database, or it can produce an SQL script that a database
administrator can run to create the database manually. If you use the tool
to create the database schema, you must have the permissions needed to
execute DDL operations."

So how do we use the auto db create mode? I did try adding the property

<property>
<name>oozie.db.schema.create</name>
<value>true</value>
</property>

To oozie-site.xml via the CM, but I still do not see the tables being
created.

Running ./ooziedb.sh create -run creates the tables in the local derby
but how do we pass the mysql parameters that are set as part of Oozie
service creation via CM?

Regards,
Vikram

To unsubscribe from this group and stop receiving emails from it, send an
email to scm-users+unsubscribe@cloudera.org.
To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 8 | next ›
Discussion Overview
groupscm-users @
categorieshadoop
postedApr 18, '14 at 1:11a
activeApr 19, '14 at 12:08a
posts8
users2
websitecloudera.com
irc#hadoop

2 users in discussion

Vikram Bajaj: 5 posts Vikram Srivastava: 3 posts

People

Translate

site design / logo © 2022 Grokbase