[
https://issues.apache.org/jira/browse/PHOENIX-2694?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15152902#comment-15152902
]
James Taylor commented on PHOENIX-2694:
---------------------------------------
Executing a {{DELETE}} only puts delete markers down, so the guideposts would
be more or less the same afterwards (until a compaction runs that actually
re-writes the HFile).
> Update statistics does not remove guideposts for deleted rows
> -------------------------------------------------------------
>
> Key: PHOENIX-2694
> URL: https://issues.apache.org/jira/browse/PHOENIX-2694
> Project: Phoenix
> Issue Type: Bug
> Reporter: Mujtaba Chohan
> Priority: Minor
>
> _Scenario with low value for {{phoenix.stats.minUpdateFrequency}} so update
> statistics can be called in short interval_:
> 1. Inserted 1M rows in a table T.
> 2. {{update statistics T}} which generated 40 guideposts in SYSTEM.STATS.
> 3. Executed {{delete from T}}
> 4. {{update statistics T}}
> 5. Got _UPDATE STATISTICS finished successfully_ message in server logs
> Result: 40 Gideposts are still in SYSTEM.STATS table for table T.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
