phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hudson (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3836) Estimated row count is twice the actual row count when stats are updated via major compaction
Date Wed, 07 Jun 2017 21:06:18 GMT

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

Hudson commented on PHOENIX-3836:
---------------------------------

FAILURE: Integrated in Jenkins build Phoenix-master #1647 (See [https://builds.apache.org/job/Phoenix-master/1647/])
PHOENIX-3836 Estimated row count is twice the actual row count when (samarth: rev 65bd849becbe961bf63c1ac1d88f0cc6a4201931)
* (edit) phoenix-core/src/it/java/org/apache/phoenix/end2end/StatsCollectorIT.java
* (edit) phoenix-core/src/main/java/org/apache/phoenix/schema/stats/DefaultStatisticsCollector.java


> Estimated row count is twice the actual row count when stats are updated via major compaction
> ---------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-3836
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3836
>             Project: Phoenix
>          Issue Type: Bug
>            Reporter: Mujtaba Chohan
>            Assignee: Samarth Jain
>             Fix For: 4.11.0
>
>         Attachments: PHOENIX-3836.patch
>
>
> Estimated row count for a 2M table is 3986498 after stats updated via major compaction
vs 1993250 with {{update statistics}}.
> {noformat}
> Explain plan for count(*) on 2M row table after major compaction:
> +--------------------------------------------------------------------------------------+
> |                                         PLAN                                      
  |
> +--------------------------------------------------------------------------------------+
> | CLIENT 364-CHUNK 3986498 ROWS 3774892993 BYTES PARALLEL 1-WAY FULL SCAN OVER T  |
> |     SERVER FILTER BY FIRST KEY ONLY                                               
  |
> |     SERVER AGGREGATE INTO SINGLE ROW                                              
  |
> +--------------------------------------------------------------------------------------+
> Explain plan for count(*) on 2M row table after update statistics:
> +--------------------------------------------------------------------------------------+
> |                                         PLAN                                      
  |
> +--------------------------------------------------------------------------------------+
> | CLIENT 364-CHUNK 1993250 ROWS 3774892993 BYTES PARALLEL 1-WAY FULL SCAN OVER T  |
> |     SERVER FILTER BY FIRST KEY ONLY                                               
  |
> |     SERVER AGGREGATE INTO SINGLE ROW                                              
  |
> +--------------------------------------------------------------------------------------+
> {noformat}
> Following schema was used with 2M rows and 10MB guidepost width:
> {noformat}
> CREATE TABLE IF NOT EXISTS T (PKA CHAR(15) NOT NULL, PKF CHAR(3) NOT NULL,
>  PKP CHAR(15) NOT NULL, CRD DATE NOT NULL, EHI CHAR(15) NOT NULL, STD_COL VARCHAR, INDEXED_COL
INTEGER,
>  CONSTRAINT PK PRIMARY KEY ( PKA, PKF, PKP, CRD DESC, EHI))
>  VERSIONS=1,MULTI_TENANT=true,IMMUTABLE_ROWS=true
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message