[jira] [Commented] (PHOENIX-2694) Update statistics does not remove guideposts for deleted rows

["James Taylor (JIRA)" <ji...@apache.org>]

    [ 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)