[OOZIE-1462] Compress lob columns before storing in database

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.1.0
• Assignee: Virag Kothari
• Reporter: Virag Kothari
• Created: 22/Jul/13 23:13
• Updated: 09/Dec/14 00:45
• Resolved: 10/Sep/13 15:43

Description

Storing huge data in lobs is very inefficient. Making Oozie compress the data before storing will reduce size of data to be stored in lobs and help in reducing the time for queries. Also most databases like oracle, mysql support storing lob data in tablerow (inline) if the data is of smaller size. Inline storage has much better performance compared to outline storage (storage outside of tablerow)

Issue Links

• breaks: OOZIE-1603 cannot submit job to oozie on mysql
• relates to: OOZIE-1548 OozieDBCLI changes to convert clob to blob and remove the discriminator column