You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Mujtaba Chohan (JIRA)" <ji...@apache.org> on 2016/02/19 02:14:18 UTC

[jira] [Created] (PHOENIX-2696) Major compaction generating wrong guideposts

Mujtaba Chohan created PHOENIX-2696:
---------------------------------------

             Summary: Major compaction generating wrong guideposts
                 Key: PHOENIX-2696
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2696
             Project: Phoenix
          Issue Type: Bug
            Reporter: Mujtaba Chohan
            Priority: Minor


With empty stats table. _Update Statistics_ correctly generate no guideposts in SYSTEM.STATS table for a table containing 0 rows (this table is major compacted after 200K rows upserted/deleted)

Again with empty stats table, after _major compaction_ of this table, following stats are generated. These stats are generated even after multiple major compactions (guidepost width is set to 5M)

{code}
+---------------------+----------------+-----------------+--------------------+--------------------------+------------------------+
|    PHYSICAL_NAME    | COLUMN_FAMILY  | GUIDE_POST_KEY  | GUIDE_POSTS_WIDTH  |  LAST_STATS_UPDATE_TIME  | GUIDE_POSTS_ROW_COUNT  |
+---------------------+----------------+-----------------+--------------------+--------------------------+------------------------+
| PERFORMANCE_200000  |                |                 | null               | 2016-02-19 01:02:50.706  | null                   |
| PERFORMANCE_200000  | STATS          | [B@21526f6c     | 5000063            |                          | 69100                  |
| PERFORMANCE_200000  | STATS          | [B@49f5c307     | 5000010            |                          | 68975                  |
| PERFORMANCE_200000  | USAGE          | [B@299266e2     | 5000060            |                          | 81022                  |
| PERFORMANCE_200000  | USAGE          | [B@5471388b     | 5000064            |                          | 78177                  |
| PERFORMANCE_200000  | USAGE          | [B@66ea1466     | 5000066            |                          | 80568                  |
| PERFORMANCE_200000  | USAGE          | [B@1601e47      | 5000020            |                          | 78600                  |
| PERFORMANCE_200000  | USAGE          | [B@3bffddff     | 5000019            |                          | 80377                  |
| PERFORMANCE_200000  | USAGE          | [B@66971f6b     | 5000016            |                          | 78591                  |
+---------------------+----------------+-----------------+--------------------+--------------------------+------------------------+
{code}





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)