Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
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…
Attachments
Attachments
Issue Links
- is related to
-
NIFI-1011 ExecuteSQL does not support Binary, VarBinary or LongVarBinary data types.
- Resolved