Hi, ExecuteSql supports streaming and full result set in not loaded into memory. Data is read continuously from ResultSet and immediately written to FlowFile.
But as Mark said result is one big FlowFile, so you can’t start reading FlowFile by next processor before it’s completed by ExecuteSql. Splitting very large FlowFile to few smaller FlowFiles can help here. Thanks Toivo -- View this message in context: http://apache-nifi-developer-list.39713.n7.nabble.com/Streaming-large-result-set-ExecuteSQL-tp5573p5581.html Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.
