[NIFI-1011] ExecuteSQL does not support Binary, VarBinary or LongVarBinary data types.

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.3.0
• Component/s: Extensions
• Environment: All
• Assignee: Unassigned
• Reporter: Scott
• Created: 30/Sep/15 17:41
• Updated: 31/Oct/15 14:18
• Resolved: 31/Oct/15 14:18

Description

When trying to get a VarBinary or Binary column there is an ArrayIndexOutOfRangeException thrown. This is because in / nifi-nar-bundles / nifi-standard-bundle / nifi-standard-processors / src / main / java / org / apache / nifi / processors / standard / util / JdbcCommon.java the data types are not supported.

I suggest adding them as Base64 encoded strings.

Issue Links

• is related to: NIFI-972 ExecuteSQL bug in createSchema() create Arvo Schema method
• relates to: NIFI-972 ExecuteSQL bug in createSchema() create Arvo Schema method