[
https://issues.apache.org/jira/browse/PHOENIX-2694?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15196956#comment-15196956
]
Ankit Singhal commented on PHOENIX-2694:
----------------------------------------
It seems to be duplicate of PHOENIX-2696.
As scanners will not return any record and no guideposts is collected , so we
are deleting old guideposts as per PHOENIX-2696.
> 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
> Labels: verify
>
> _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)
