phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (PHOENIX-4674) Incorrect stats if data size is less than guidepost width
Date Mon, 30 Apr 2018 23:42:00 GMT

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

James Taylor resolved PHOENIX-4674.
-----------------------------------
    Resolution: Not A Problem

> Incorrect stats if data size is less than guidepost width
> ---------------------------------------------------------
>
>                 Key: PHOENIX-4674
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-4674
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Abhishek Singh Chouhan
>            Assignee: Abhishek Singh Chouhan
>            Priority: Major
>         Attachments: PHOENIX-4674.patch
>
>
> For a small table, lets say with a single region < guidepost width, the stats after
running update statistics can be way off. This is because we get an empty guidepost for the
region and in BaseResultIterators we end up estimating the #rows as guidepostwidth/estimated
row size of the table. For a table having <100 rows and guidepost width size of 100 mb,
if the estimated row size is 100 bytes we end up estimating a million rows.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message