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

Add Fetch Size property to QueryDatabaseTable processor

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.6.0
    • Fix Version/s: 0.7.0, 0.6.1
    • Component/s: None
    • Labels:
      None

      Description

      The QueryDatabaseTable processor does not have a way for the user to set the fetch size for the JDBC query. Some drivers (like Oracle) default to a fetch size of 1, which means result rows needs to be fetched one at a time from the database. This can be very slow, an improvement would be to allow the user to set the fetch size for the query.

      NOTE: Some drivers do not support this, either by throwing an exception or ignoring it (the JDBC spec marks it as a "hint to the database", the doc for the property should make this clear and no exception should be propagated through the processor if the attempt to set fetch size is unsuccessful.

        Attachments

          Activity

            People

            • Assignee:
              mattyb149 Matt Burgess
              Reporter:
              mattyb149 Matt Burgess
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: