Uploaded image for project: 'CDAP'
  1. CDAP
  2. CDAP-5062

Make fetchsize in Explore JDBC driver configurable

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.4.0
    • Component/s: Explore
    • Labels:
      None
    • Release Notes:
      Added a 'fetch.size' connection setting to the jdbc driver to control the number of rows fetched per database cursor. Also increased the default from 50 to 1000.
    • Rank:
      1|hzz7hb:

      Description

      Explore JDBC driver has fetchSize that is hardcoded to 50.

      1. The default limit should be high 1000
      2. We should make this configurable via jdbc connection string property

      https://github.com/caskdata/cdap/blob/develop/cdap-explore-jdbc/src/main/java/co/cask/cdap/explore/jdbc/ExploreStatement.java#L43-L46

        Attachments

          Activity

            People

            • Assignee:
              ashau Albert Shau
              Reporter:
              sree Sreevatsan Raman
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: