Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-972

ExecuteSQL bug in createSchema() create Arvo Schema method

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.4.0
    • Component/s: Extensions
    • Labels:
      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

        1. nifi-972_01oct2015.patch
          23 kB
          Toivo Adams
        2. NIFI-972_23oct2015.patch
          30 kB
          Toivo Adams

          Issue Links

            Activity

              People

              • Assignee:
                Toivo Adams Toivo Adams
                Reporter:
                Toivo Adams Toivo Adams
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: