Configure Oozie to use MySQL

0 votes
Hi. I have recently installed Oozie and MySQL and I want to set up oozie such that it used MySQL database. How to do this?
Jun 4 in Big Data Hadoop by Rajat
16 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

To configure Oozie to use MySQL, open the oozie-site.xml file and add the following properties:

    <property>
        <name>oozie.service.JPAService.jdbc.driver</name>
        <value>com.mysql.jdbc.Driver</value>
    </property>
    <property>
        <name>oozie.service.JPAService.jdbc.url</name>
        <value>jdbc:mysql://localhost:3306/oozie</value>
    </property>
    <property>
        <name>oozie.service.JPAService.jdbc.username</name>
        <value>oozie</value>
    </property>
    <property>
        <name>oozie.service.JPAService.jdbc.password</name>
        <value>oozie</value>
    </property>
answered Jun 4 by Karan

Related Questions In Big Data Hadoop

0 votes
1 answer

Configure Oozie to use PostgreSQL

To configure Oozie to use PostgreSQL, add ...READ MORE

answered Jun 4 in Big Data Hadoop by Rajan
13 views
0 votes
1 answer

How to configure the metastore service to communicate with the MySQL database in Hive?

Hey, This step shows the configuration properties you ...READ MORE

answered May 29 in Big Data Hadoop by Gitika
• 14,110 points
15 views
0 votes
1 answer

How to configure the Hadoop cluster with proxyuser for the Oozie process?

Hey, The following two properties are required in ...READ MORE

answered Jun 10 in Big Data Hadoop by Gitika
• 14,110 points
15 views
0 votes
1 answer
0 votes
1 answer

Update hdfs data before stroring in MySql

Yes, you can update the data before ...READ MORE

answered Jan 27 in Big Data Hadoop by Omkar
• 66,880 points
18 views
0 votes
1 answer

Using Hadoop for Data Analytics.

Yes, your approach is correct - you ...READ MORE

answered Sep 28, 2018 in Big Data Hadoop by Frankie
• 9,710 points
23 views
0 votes
1 answer

How to open MySql console in Ubuntu?

sudo service mysqld restart mysql -u <username> root ...READ MORE

answered Dec 14, 2018 in Big Data Hadoop by Omkar
• 66,880 points
63 views
0 votes
1 answer

Facing the below error while installing mysql in VM

We would like to say that the ...READ MORE

answered Dec 21, 2018 in Big Data Hadoop by Omkar
• 66,880 points
44 views
0 votes
1 answer

Configure Oozie to use MariaDB

Add the following properties in the oozie-site.xml file, it ...READ MORE

answered Jun 4 in Big Data Hadoop by Esha
13 views
0 votes
1 answer

How to configure Oozie to use Oracle?

You have to mention the following properties ...READ MORE

answered Jun 6 in Big Data Hadoop by Rishi
11 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.