nifi-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Peter Wicks (Jira)" <j...@apache.org>
Subject [jira] [Created] (NIFI-6862) Add Large Batch support to PutSQL
Date Tue, 12 Nov 2019 14:53:00 GMT
Peter Wicks created NIFI-6862:
---------------------------------

             Summary: Add Large Batch support to PutSQL
                 Key: NIFI-6862
                 URL: https://issues.apache.org/jira/browse/NIFI-6862
             Project: Apache NiFi
          Issue Type: Task
          Components: Extensions
            Reporter: Peter Wicks
            Assignee: Peter Wicks


If PutSQL executes an Insert Statement that selects from table `A` and inserts into table
`B` the affected row count can exceed Int32.MaxValue.  This causes the execution to fail
because the affected row count can't be captured as an integer.

The fix is to execute using `executeLargeUpdate`, which returns the affected row count as
a long. Not all JDBC drivers support executing large batches, so we need to support current
`executeBatch` mode as well, with users opting in to Large Batch mode.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message