Toivo Adams created NIFI-972:
--------------------------------
Summary: ExecuteSQL bug in createSchema() create Arvo Schema method
Key: NIFI-972
URL: https://issues.apache.org/jira/browse/NIFI-972
Project: Apache NiFi
Issue Type: Bug
Reporter: Toivo Adams
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…
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
