Page MenuHomePhabricator

Backfill pageview_hourly sanitization - 1 month - {hawk} - DUPLICATE THIS TASK FOR EACH MONTH TO BACKFILL
Closed, DuplicatePublic8 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 added a subscriber: JAllemandou.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptNov 17 2015, 10:38 AM
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.
Milimetric moved this task from Blocked to Dashiki on the Analytics board.Jun 2 2016, 5:21 PM
Nuria moved this task from Dashiki to Backlog (Later) on the Analytics board.Jul 4 2016, 5:00 PM
Nuria moved this task from Wikistats Production to Dashiki on the Analytics board.Jan 6 2017, 4:37 PM
Nuria moved this task from Dashiki to Backlog (Later) on the Analytics board.May 16 2017, 12:50 PM
Nuria moved this task from Backlog (Later) to Dashiki on the Analytics board.Jan 11 2018, 5:32 PM