Page MenuHomePhabricator

Backfill pageview_hourly sanitization - 1 month - {hawk} - DUPLICATE THIS TASK FOR EACH MONTH TO BACKFILL
Closed, DuplicatePublic8 Estimated Story Points

Description

Data in the pageview_hourly table is sanitized from the deploy day of the sanitization process.
We need to update the table with sanitized data, based on the data already in the table.
Process:
Create a new temporary pageview external table.
Fill the new table with sanitized pageview using existing pageview_hourly table for the given month.
Move exisitng pageview_hourly into a safe place, in order not to loose that data if anything go wrong. - DON'T DELETE THAT DATA YET :)
Move the newly computed data in the empty pageview_hourly folders.

Event Timeline

JAllemandou raised the priority of this task from to High.
JAllemandou updated the task description. (Show Details)
JAllemandou added a project: Analytics-Backlog.
JAllemandou subscribed.
Milimetric renamed this task from Backfill pageview_hourly sanitization - 1 month - [8 pts] {hawk} - DUPLICATE THIS TASK FOR EACH MONTH TO BACKFILL to Backfill pageview_hourly sanitization - 1 month - {hawk} - DUPLICATE THIS TASK FOR EACH MONTH TO BACKFILL.Feb 22 2016, 9:07 PM
Milimetric set the point value for this task to 8.