hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bing Li (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-10982) Customizable the value of java.sql.statement.setFetchSize in Hive JDBC Driver
Date Tue, 01 Dec 2015 04:38:10 GMT

    [ https://issues.apache.org/jira/browse/HIVE-10982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15033062#comment-15033062
] 

Bing Li commented on HIVE-10982:
--------------------------------

Hi, [~alangates]
I just submitted the patch, and it could work well in my local envirment.
Could you review it?

Thank you.

> Customizable the value of  java.sql.statement.setFetchSize in Hive JDBC Driver
> ------------------------------------------------------------------------------
>
>                 Key: HIVE-10982
>                 URL: https://issues.apache.org/jira/browse/HIVE-10982
>             Project: Hive
>          Issue Type: Improvement
>          Components: JDBC
>    Affects Versions: 1.2.0, 1.2.1
>            Reporter: Bing Li
>            Assignee: Bing Li
>            Priority: Critical
>         Attachments: HIVE-10982.1.patch, HIVE-10982.2.patch
>
>
> The current JDBC driver for Hive hard-code the value of setFetchSize to 50, which will
be a bottleneck for performance.
> Pentaho filed this issue as  http://jira.pentaho.com/browse/PDI-11511, whose status is
open.
> Also it has discussion in http://forums.pentaho.com/showthread.php?158381-Hive-JDBC-Query-too-slow-too-many-fetches-after-query-execution-Kettle-Xform
> http://mail-archives.apache.org/mod_mbox/hive-user/201307.mbox/%3CCACQ46vEVGrfqG5rWXNr1PSgYz7dcF07mvLo8MM2qiT3ANM1XvQ@mail.gmail.com%3E



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message