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 5 automatically configures Oozie with all available official schemas, and corresponding tables, per the latest CDH 5.x release. For all versions of CDH 4.x, Cloudera Manager configures Oozie with the CDH 4.0.0 schema, even if you are using a higher version of CDH 4.x.

  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 5 or Oozie Schema - CDH 4, appending .xsd to each entry.

    If more than one role group applies to this configuration, edit the value for the appropriate role group. See Modifying Configuration Properties Using Cloudera Manager.

  7. Click Save Changes to commit the changes.
  8. Restart the Oozie service.
Oozie Schema - CDH 5
  CDH 5.6.0 CDH 5.5.0 CDH 5.4.0 CDH 5.2.0 CDH 5.1.0 CDH 5.0.1

distcp

distcp-action-0.1

distcp-action-0.2

distcp-action-0.1

distcp-action-0.2

distcp-action-0.1

distcp-action-0.2

distcp-action-0.1

distcp-action-0.2

distcp-action-0.1

distcp-action-0.2

distcp-action-0.1

distcp-action-0.2

email

email-action-0.1

email-action-0.2

email-action-0.1

email-action-0.2

email-action-0.1

email-action-0.2

email-action-0.1

email-action-0.2

email-action-0.1

email-action-0.2

email-action-0.1

hive

hive-action-0.2

hive-action-0.3

hive-action-0.4

hive-action-0.5

hive-action-0.6 

hive-action-0.2

hive-action-0.3

hive-action-0.4

hive-action-0.5

hive-action-0.6 

hive-action-0.2

hive-action-0.3

hive-action-0.4

hive-action-0.5

hive-action-0.2

hive-action-0.3

hive-action-0.4

hive-action-0.5

hive-action-0.2

hive-action-0.3

hive-action-0.4

hive-action-0.5

hive-action-0.2

hive-action-0.3

hive-action-0.4

hive-action-0.5

HiveServer2

hive2-action-0.1

hive2-action-0.2 

hive2-action-0.1

hive2-action-0.2 

hive2-action-0.1

hive2-action-0.1

   

oozie-bundle

hive2-action-0.1

hive2-action-0.1

hive2-action-0.1

hive2-action-0.1

oozie-bundle-0.1

oozie-bundle-0.2

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

oozie-coordinator-0.2

oozie-coordinator-0.3

oozie-coordinator-0.4

oozie-coordinator-0.1

oozie-coordinator-0.2

oozie-coordinator-0.3

oozie-coordinator-0.4

oozie-coordinator-0.1

oozie-coordinator-0.2

oozie-coordinator-0.3

oozie-coordinator-0.4

oozie-coordinator-0.1

oozie-coordinator-0.2

oozie-coordinator-0.3

oozie-coordinator-0.4

oozie-coordinator-0.1

oozie-coordinator-0.2

oozie-coordinator-0.3

oozie-coordinator-0.4

oozie-sla

oozie-sla-0.1

oozie-sla-0.2

oozie-sla-0.1

oozie-sla-0.2

oozie-sla-0.1

oozie-sla-0.2

oozie-sla-0.1

oozie-sla-0.2

oozie-sla-0.1

oozie-sla-0.2

oozie-sla-0.1

oozie-sla-0.2

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

shell

shell-action-0.1

shell-action-0.2

shell-action-0.3

shell-action-0.1

shell-action-0.2

shell-action-0.3

shell-action-0.1

shell-action-0.2

shell-action-0.3

shell-action-0.1

shell-action-0.2

shell-action-0.3

shell-action-0.1

shell-action-0.2

shell-action-0.3

shell-action-0.1

shell-action-0.2

shell-action-0.3

spark

spark-action-0.1 spark-action-0.1 spark-action-0.1      

sqoop

sqoop-action-0.2

sqoop-action-0.3

sqoop-action-0.4

sqoop-action-0.2

sqoop-action-0.3

sqoop-action-0.4

sqoop-action-0.2

sqoop-action-0.3

sqoop-action-0.4

sqoop-action-0.2

sqoop-action-0.3

sqoop-action-0.4

sqoop-action-0.2

sqoop-action-0.3

sqoop-action-0.4

sqoop-action-0.2

sqoop-action-0.3

sqoop-action-0.4

ssh

ssh-action-0.1

ssh-action-0.2

ssh-action-0.1

ssh-action-0.2

ssh-action-0.1

ssh-action-0.2

ssh-action-0.1

ssh-action-0.2

ssh-action-0.1

ssh-action-0.2

ssh-action-0.1

ssh-action-0.2

Oozie Schema - CDH 4
  CDH 4.3.0 CDH 4.2.0 CDH 4.1.0 CDH 4.0.0

distcp

distcp-action-0.1

distcp-action-0.2

distcp-action-0.1

distcp-action-0.2

distcp-action-0.1

distcp-action-0.1

email

email-action-0.1

email-action-0.1

email-action-0.1

email-action-0.1

hive

hive-action-0.2

hive-action-0.3

hive-action-0.4

hive-action-0.5

hive-action-0.2

hive-action-0.3

hive-action-0.4

hive-action-0.2

hive-action-0.3

hive-action-0.4

hive-action-0.2

oozie-bundle

oozie-bundle-0.1

oozie-bundle-0.2

oozie-bundle-0.1

oozie-bundle-0.2

oozie-bundle-0.1

oozie-bundle-0.2

oozie-bundle-0.1

oozie-coordinator

oozie-coordinator-0.1

oozie-coordinator-0.2

oozie-coordinator-0.3

oozie-coordinator-0.4

oozie-coordinator-0.1

oozie-coordinator-0.2

oozie-coordinator-0.3

oozie-coordinator-0.4

oozie-coordinator-0.1

oozie-coordinator-0.2

oozie-coordinator-0.3

oozie-coordinator-0.4

oozie-coordinator-0.1

oozie-coordinator-0.2

oozie-coordinator-0.3

oozie-sla

oozie-sla-0.1

oozie-sla-0.1

oozie-sla-0.1

oozie-sla-0.1

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

oozie-workflow-0.2

oozie-workflow-0.2.5

oozie-workflow-0.3

oozie-workflow-0.4

oozie-workflow-0.1

oozie-workflow-0.2

oozie-workflow-0.2.5

oozie-workflow-0.3

oozie-workflow-0.4

oozie-workflow-0.1

oozie-workflow-0.2

oozie-workflow-0.2.5

oozie-workflow-0.3

shell

shell-action-0.1

shell-action-0.2

shell-action-0.3

shell-action-0.1

shell-action-0.2

shell-action-0.3

shell-action-0.1

shell-action-0.2

shell-action-0.3

shell-action-0.1

sqoop

sqoop-action-0.2

sqoop-action-0.3

sqoop-action-0.4

sqoop-action-0.2

sqoop-action-0.3

sqoop-action-0.4

sqoop-action-0.2

sqoop-action-0.3

sqoop-action-0.4

sqoop-action-0.2

ssh

ssh-action-0.1

ssh-action-0.2

ssh-action-0.1

ssh-action-0.1

ssh-action-0.1