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

Search Discussions

Discussion Posts

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 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