hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Mollitor (Jira)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-23005) Consider Default JDBC Fetch Size From HS2
Date Wed, 11 Mar 2020 13:19:00 GMT

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

David Mollitor updated HIVE-23005:
----------------------------------
    Status: Patch Available  (was: Open)

Was not setting fetch size with hint of 0 correctly in constructor.  Supplied new 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)

Mime
View raw message