Data Lake for Enterprises

Database setup and configuration

Oozie requires a metastore to store information for Oozie jobs, workflows and coordinators, hence we will need to create a metastore database. As done earlier for other technologies in regards to metastore,we will create and configure this metastore in PostgreSQL Follow the steps below to configure PostgreSQL as our metastore database:

1. Login into PostgreSQL prompt in ssh/command line within CentOS VM:

psql -U postgres

2. Create the Oozie user by running the following query:

CREATE ROLE oozie LOGIN ENCRYPTED PASSWORD 'oozie' NOSUPERUSER INHERIT CREATEDB NOCREATEROLE;

3. Create the Oozie database by running the below query:

CREATE DATABASE "oozie" WITH OWNER = oozieENCODING = 'UTF8'TABLESPACE = pg_default ...