title: Nifi ExecuteSQL fetching record in chunk
body: <p>I am trying to fetch data from mysql in batches ( <code>just like cursor</code>) using ExecuteSQL processor.  My ExecuteSQL attributes are :</p>
  
  <pre><code>Max Rows Per Flow File :  100
  Output Batch Size : 10
  </code></pre>
  
  <p>But Processor is stuck unless it executes and fetches all the data.  I need to simulate cursor like scenario here. </p>
  
  <p>Like as soon as mysql sends some data say 100 it create a flowfile from it and when 10 such flow file are created processor send down the line to process.</p>