Adding schema to Oozie using Cloudera Manager

Cloudera Manager automatically configures Oozie with all available official schemas, and corresponding tables. You can manually add a schema (official or custom) with Cloudera Manager.

  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 the following schema list appending .xsd to each entry.
    To apply this configuration property to other role groups as needed, edit the value for the appropriate role group.
  7. Enter a Reason for change, and then click Save Change to commit the changes.
  8. Restart the Oozie service.
    Table 1. Oozie schema
    Schema CDP

    distcp

    distcp-action-0.1

    distcp-action-0.2

    distcp-action-1.0

    email

    email-action-0.1

    email-action-0.2

    git

    git-action-1.0

    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