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.
To unsubscribe from this group and stop receiving emails from it, send an email to scm-users+unsubscribe@cloudera.org.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.
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.
