[
https://issues.apache.org/jira/browse/PHOENIX-2696?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15153759#comment-15153759
]
James Taylor commented on PHOENIX-2696:
---------------------------------------
Is KEEP_DELETED_CELLS set to true, [~mujtabachohan]?
[~ankit.singhal] - would you mind investigating?
> 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)
