I think this post is based on an erroneous assumption that SQL statements need to be identical to be batched by the PutSQL processor. Perhaps the misunderstanding was because Support Fragmented Transactions was set to true (the default) which will fragment the batch unless you are using fragment.identifier to correctly identify your batches. https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.5.0/org.apache.nifi.processors.standard.PutSQL/index.html ... View more

Why "PutSQL Processor is unable to perform the batch inserts although a batch size had been configured in the processor."?? Why isn't it just changed to allow SQL statements that are not identical be batched, instead of having to do it this way? Of course SQL statements will almost certainly be different from one another! Sounds like a bug in the processor... ... View more