[LENS-1333] Add data completeness checker

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.7
• Component/s: cube
• Assignee: Narayan Periwal
• Reporter: Amareshwari Sriramadasu
• Created: 20/Sep/16 08:40
• Updated: 11/Nov/16 05:57
• Resolved: 11/Nov/16 03:37

Description

Though lens has partition registration being done whenever data is available, there is no guarantee the partition registered is complete. There can be different ways to know if the data is complete for partition. One option could be to have a partition property saying whether it is complete or not. Other could be to do a http call to another hosted service and more.

Proposal here is to add an interface for DataCompletenessChecker and do the check while resolving partitions.

Here are some of the capabilities we would like to add in Lens :

1. Lens will check partition existence first, if it exists, then check the completeness percentage. If the completeness percentage is less than a configured threshold (default should be 98, 99 or even 100), Lens will fail the query.
2. Lens's accept query on partial data will accept on incomplete data as well.
3. Lens will also option to override the completeness percentage threshold value at query level
4. Lens will still have look ahead capability of daily being incomplete, then it will union with hourly.
5. If same measure is there in two different facts , Lens will we pick the one with higher availability.
6. In case of completeness percentage threshold missed, Lens will respond back with available percentage.

Issue Links

• links to: Review Board

Sub-Tasks

• Adding API for data completeness checker: Closed