You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by alex kamil <al...@gmail.com> on 2014/03/10 18:11:58 UTC

setFetchSize

are there any plans to implement setFetchSize in PhoenixStatement?

 when retrieving large number of rows the resultSet generates lots of
network calls back to Hbase


phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixStatement.java:

 @Override

    public void setFetchSize(int rows) throws SQLException {

        // TODO: map to Scan.setBatch() ?

        throw new SQLFeatureNotSupportedException();

    }

Re: setFetchSize

Posted by alex kamil <al...@gmail.com>.

thanks, James,

will use hbase.client.scanner.caching

Alex


On Mon, Mar 10, 2014 at 3:00 PM, James Taylor <ja...@apache.org>wrote:

> The getFetchSize() is already based on the hbase.client.scanner.caching
> setting, so there's not a big need. The only advantage would be if per
> statement you wanted different caching. Is that the case for you?
>
> Thanks,
> James
>
>
> On Mon, Mar 10, 2014 at 10:11 AM, alex kamil <al...@gmail.com> wrote:
>
>> are there any plans to implement setFetchSize in PhoenixStatement?
>>
>>  when retrieving large number of rows the resultSet generates lots of
>> network calls back to Hbase
>>
>>
>>
>> phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixStatement.java:
>>
>>  @Override
>>
>>     public void setFetchSize(int rows) throws SQLException {
>>
>>         // TODO: map to Scan.setBatch() ?
>>
>>         throw new SQLFeatureNotSupportedException();
>>
>>     }
>>
>
>

Re: setFetchSize

Posted by James Taylor <ja...@apache.org>.

The getFetchSize() is already based on the hbase.client.scanner.caching
setting, so there's not a big need. The only advantage would be if per
statement you wanted different caching. Is that the case for you?

Thanks,
James

On Mon, Mar 10, 2014 at 10:11 AM, alex kamil <al...@gmail.com> wrote:

> are there any plans to implement setFetchSize in PhoenixStatement?
>
>  when retrieving large number of rows the resultSet generates lots of
> network calls back to Hbase
>
>
>  phoenix-core/src/main/java/org/apache/phoenix/jdbc/PhoenixStatement.java:
>
>  @Override
>
>     public void setFetchSize(int rows) throws SQLException {
>
>         // TODO: map to Scan.setBatch() ?
>
>         throw new SQLFeatureNotSupportedException();
>
>     }
>