[NIFI-972] ExecuteSQL bug in createSchema() create Arvo Schema method

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Extensions
• Assignee: Toivo Adams
• Reporter: Toivo Adams
• Created: 17/Sep/15 15:37
• Updated: 23/Oct/15 14:14
• Resolved: 23/Oct/15 14:14

Description

Jonathan Lyons reported:

Just getting started with NiFi here. I am attempting to run a static query
in MySQL using the ExecuteSQL processor. It is set to run on a 5 second
interval. Since ExecuteSQL appears to need an input flow file I'm using a
GenerateFlowFile processor to produce a random file every 5 seconds.
Unfortunately, I'm getting a very vague ArrayIndexOutOfBounds exception
when I hit play on the flow:

java.lang.ArrayIndexOutOfBoundsException: 8
at org.apache.avro.generic.GenericData$Record.put(GenericData.java:129)
at org.apache.nifi.processors.standard.util.JdbcCommon.convertToAvroStream
at
org.apache.nifi.processors.standard.ExecuteSQL$1.process(ExecuteSQL.java:141)

It’s seem to be bug in createSchema() which creates Arvo schema.
When createSchema() will encounter unknown type, no Arvo column info will be created. And Arvo schema has less columns than ResultSet row…

Issue Links

• is related to: NIFI-1011 ExecuteSQL does not support Binary, VarBinary or LongVarBinary data types.
• relates to: NIFI-1049 ExecuteSQL generates NPE on any null valued column
• relates to: NIFI-1029 Need to add a new attriibute to ExecuteSQL to indicate how many rows were selected
• relates to: NIFI-1011 ExecuteSQL does not support Binary, VarBinary or LongVarBinary data types.