[ https://issues.apache.org/jira/browse/HIVE-23005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Mollitor updated HIVE-23005: ---------------------------------- Attachment: HIVE-23005.3.patch > Consider Default JDBC Fetch Size From HS2 > ----------------------------------------- > > Key: HIVE-23005 > URL: https://issues.apache.org/jira/browse/HIVE-23005 > Project: Hive > Issue Type: Sub-task > Components: JDBC > Reporter: David Mollitor > Assignee: David Mollitor > Priority: Major > Attachments: HIVE-23005.1.patch, HIVE-23005.2.patch, > HIVE-23005.3.patch > > > # Create two fetch sizes: and "init" fetch size and a "default" fetch size. > The "init" fetch size comes from the JDBC connection string _fetchSize_ (if > present) and the "default" fetch size comes from > _HIVE_SERVER2_THRIFT_RESULTSET_DEFAULT_FETCH_SIZE_ the server response to the > open session request. > # When a {{Statement}} is created, its starting fetch size is the "init" > fetch size (may be 0) > # Manually setting the fetch size on the {{Statement}} to 0, sets the fetch > size to be the server default > Setting to zero defaults to the server's instructed default and adheres to: > bq. If the value specified is zero, then the hint is ignored. The default > value is zero. > That is to say, if the fetch size is 0, the default from the server is used, > otherwise the user can pass a 'hint' and that will be the number of rows > fetched instead. > https://docs.oracle.com/javase/8/docs/api/java/sql/Statement.html#setFetchSize-int- -- This message was sent by Atlassian Jira (v8.3.4#803005)