[OOZIE-1636] OOZIE_SYS table engine should be innodb

• Type: Improvement
• Status: Patch Available
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: trunk, 4.1.0
• Fix Version/s: trunk
• Component/s: tools
• Assignee: Unassigned
• Reporter: Jay Sen
• Created: 08/Dec/13 09:27
• Updated: 13/Mar/18 00:07

Description

All oozie table are created with engine set to innodb explicitly but OOZIE_SYS table does not have engine specified which defaults to whatever mysql default engine is, which could be myisam sometimes.

This could be easily missed and create problem while taking database backup.

so this ticket is for specifying engine innodb for OOZIE_SYS explicitly while creating oozie.sql