[EAGLE-292] Updated hbase policy failed: Data too long for column 'policyDef' when using mysql storage

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: v0.4.0
• Fix Version/s: v0.4.0
• Assignee: Da Zhou
• Reporter: Da Zhou
• Created: 04/May/16 18:54
• Updated: 15/Jun/16 03:57
• Resolved: 15/Jun/16 03:57

Description

When creating hbase policy, if there are too many match criteria error message will occur:
"Updatefailed!{"success":false,"exception":"java.io.IOException: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'policyDef' at row 1\norg.apache.eagle.storage.jdbc.JdbcStorage.create(JdbcStorage.java:97)\norg.apache.eagle.storage.operation.CreateStatement.execute(CreateStatement.java:63)"

Issue Links

• Blocked: EAGLE-273 Issue with creating MySql tables , only 14 were created out of 24, reason being varchar(30000) for multiple columns lead to exceeding the maximum row size of 65,535 bytes.