You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@phoenix.apache.org by "Jaanai (JIRA)" <ji...@apache.org> on 2018/10/16 12:53:00 UTC
[jira] [Comment Edited] (PHOENIX-4974) Gets all regions uses get
requests is extremely slows for big table
[ https://issues.apache.org/jira/browse/PHOENIX-4974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16651617#comment-16651617 ]
Jaanai edited comment on PHOENIX-4974 at 10/16/18 12:52 PM:
------------------------------------------------------------
!performance.png|width=436,height=186!
Gets performance gains more than 10 times
was (Author: jaanai):
!performance.png! Gets performance gains more than 10 times
> Gets all regions uses get requests is extremely slows for big table
> --------------------------------------------------------------------
>
> Key: PHOENIX-4974
> URL: https://issues.apache.org/jira/browse/PHOENIX-4974
> Project: Phoenix
> Issue Type: Improvement
> Affects Versions: 4.14.0, 5.0.0
> Reporter: Jaanai
> Assignee: Jaanai
> Priority: Major
> Attachments: PHOENIX-4974-master.patch, performance.png
>
>
> When executes the first query after started the client(SQLline or initializing JDBC client ), needs to load region locations to the client cache. Now the following is key implement :
> {code:java}
> List<HRegionLocation> locations = Lists.newArrayList();
> byte[] currentKey = HConstants.EMPTY_START_ROW;
> do {
> HRegionLocation regionLocation = connection.getRegionLocation(
> TableName.valueOf(tableName), currentKey, reload);
> locations.add(regionLocation);
> currentKey = regionLocation.getRegionInfo().getEndKey();
> } while (!Bytes.equals(currentKey, HConstants.EMPTY_END_ROW));
> {code}
> For some big tables which have more than ten thousand regions, this procedure is extremely slow.
> Runs a look points query on the table that has 10000 regions after starting the client, it needs 25+ seconds.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)