[ 
https://issues.apache.org/jira/browse/PHOENIX-5735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17045825#comment-17045825
 ] 

Geoffrey Jacoby commented on PHOENIX-5735:
------------------------------------------

I think it's more complicated than "inline verifiation should not verify rows 
beyond max lookback age". If you did that, and had a table with many years 
worth of data, and a max lookback age of 7 days, you'd only ever verify a 
week's worth of data, which could be a tiny fraction of whole. 

What actually needs to be verified are all values that are _visible_ within the 
max lookback day period. So, for a table with max lookback age of A:

If the latest version has a timestamp from time 0 to time A: only verify the 
latest version of the Cell
If the latest version has a timestamp greater than A: verify all cells whose 
timestamp is greater than A

This way you verify all versions that might be visible to any valid 
lookback/SCN query.  

> IndexTool's inline verification should not verify rows beyond max lookback age
> ------------------------------------------------------------------------------
>
>                 Key: PHOENIX-5735
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5735
>             Project: Phoenix
>          Issue Type: Improvement
>            Reporter: Swaroopa Kadam
>            Assignee: Weiming Wang
>            Priority: Major
>             Fix For: 5.1.0, 4.15.1
>
>
> IndexTool's inline verification should not verify rows beyond max lookback age
> Similar to Phoenix-5734



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to