You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Samarth Jain (JIRA)" <ji...@apache.org> on 2017/10/31 21:13:01 UTC
[jira] [Comment Edited] (PHOENIX-4333) Stats - Incorrect estimate
when stats are updated on a tenant specific view
[ https://issues.apache.org/jira/browse/PHOENIX-4333?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16227597#comment-16227597 ]
Samarth Jain edited comment on PHOENIX-4333 at 10/31/17 9:12 PM:
-----------------------------------------------------------------
Test which demonstrates the issue that [~mujtabachohan] brought up. I would say it is working as designed. We call these estimates for a reason :). If the user desires more accuracy, he/she should call UPDATE STATISTICS on the tenant view.
FYI, [~cody.marcel@gmail.com]
was (Author: samarthjain):
Test which demonstrates the issue that [~mujtabachohan] brought up. I would say it is working fine. We call these estimates for a reason :). If the user desires more accuracy, he/she should call UPDATE STATISTICS on the tenant view.
FYI, [~cody.marcel@gmail.com]
> Stats - Incorrect estimate when stats are updated on a tenant specific view
> ---------------------------------------------------------------------------
>
> Key: PHOENIX-4333
> URL: https://issues.apache.org/jira/browse/PHOENIX-4333
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.12.0
> Reporter: Mujtaba Chohan
> Assignee: Samarth Jain
> Attachments: PHOENIX-4333_test.patch
>
>
> Consider two tenants A, B with tenant specific view on 2 separate regions/region servers.
> {noformat}
> Region 1 keys:
> A,1
> A,2
> B,1
> Region 2 keys:
> B,2
> B,3
> {noformat}
> When stats are updated on tenant A view. Querying stats on tenant B view yield partial results (only contains stats for B,1) which are incorrect even though it shows updated timestamp as current.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)