[ 
https://issues.apache.org/jira/browse/HIVE-23005?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

David Mollitor updated HIVE-23005:
----------------------------------
    Attachment:     (was: HIVE-23005.2.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
>
>
> # 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)

Reply via email to