Adding Schema to Oozie Using Cloudera Manager

Minimum Required Role: Configurator (also provided by Cluster Administrator, Full Administrator)

This page explains how to manually add a schema (official or custom) with Cloudera Manager.

Cloudera Manager automatically configures Oozie with all available official schemas, and corresponding tables, per the latest CDH release.

  1. In the Cloudera Manager Admin Console, go to the Oozie service.
  2. Click the Configuration tab.
  3. Select Scope > Oozie Server.
  4. Select Category > Advanced.
  5. Locate the Oozie SchemaService Workflow Extension Schemas property or search for it by typing its name in the Search box.
  6. Enter the desired schema from Oozie Schema - CDH 6 appending .xsd to each entry.

    To apply this configuration property to other role groups as needed, edit the value for the appropriate role group. See Modifying Configuration Properties Using Cloudera Manager.

  7. Enter a Reason for change, and then click Save Changes to commit the changes.
  8. Restart the Oozie service.
Oozie Schema - CDH 6
Schema CDH 6.0

distcp

distcp-action-0.1

distcp-action-0.2

distcp-action-1.0

email

email-action-0.1

email-action-0.2

hive

hive-action-0.2

hive-action-0.3

hive-action-0.4

hive-action-0.5

hive-action-0.6 

hive-action-1.0

HiveServer2

hive2-action-0.1

hive2-action-0.2

 hive2-action-1.0

oozie-bundle

oozie-bundle-0.1

oozie-bundle-0.2

oozie-coordinator

oozie-coordinator-0.1

oozie-coordinator-0.2

oozie-coordinator-0.3

oozie-coordinator-0.4

oozie-coordinator-0.5

oozie-sla

oozie-sla-0.1

oozie-sla-0.2

oozie-common oozie-common-1.0

oozie-workflow

oozie-workflow-0.1

oozie-workflow-0.2

oozie-workflow-0.2.5

oozie-workflow-0.3

oozie-workflow-0.4

oozie-workflow-0.4.5

oozie-workflow-0.5

oozie-workflow-1.0

shell

shell-action-0.1

shell-action-0.2

shell-action-0.3

shell-action-1.0

spark

spark-action-0.1

spark-action-0.2

spark-action-1.0

sqoop

sqoop-action-0.2

sqoop-action-0.3

sqoop-action-0.4

sqoop-action-1.0

ssh

ssh-action-0.1

ssh-action-0.2