Page MenuHomePhabricator
Create Task
Maniphest T243559

Homepage: delete data from tables in nettrom_growth
Closed, ResolvedPublic
Actions

Description

We have three tables in Hive that contains EventLogging data from the Homepage experiment that @nettrom_WMF created:

  1. nettrom_growth.homepage_helppanel_backup This table contains events from the Homepage created through the Mentor or Help Desk modules (ref: T234857).
  2. nettrom_growth.homepagevisit_05 This table contains sanitized data from event.homepagevisit for May 2019, because our whitelisting was implemented at a time that left out some data from earlier that month.
  3. nettrom_growth.homepagemodule_05 Same as for the homepagevisit_05 table.

@nettrom_WMF will delete these tables before the Feb 6, 2020 deadline.

Related Objects
Search...

Event Timeline

• nettrom_WMF created this task.Jan 23 2020, 10:29 PM
• nettrom_WMF edited parent tasks, added: T243557: Homepage: purge old data; removed: T243558: Homepage: produce final status report prior to purging data.
• nettrom_WMF triaged this task as High priority.Feb 3 2020, 5:43 PM
• nettrom_WMF edited projects, added: Product-Analytics (Kanban); removed: Product-Analytics.
• nettrom_WMF updated the task description. (Show Details)Feb 5 2020, 12:16 AM
• nettrom_WMF closed this task as Resolved.Feb 5 2020, 12:20 AM

These tables have now been deleted, ref the terminal session shown below. Closing this task as resolved.

hive (nettrom_growth)> DROP TABLE homepage_helppanel_backup;
OK
Time taken: 0.148 seconds
hive (nettrom_growth)> DROP TABLE homepagevisit_05;
OK
Time taken: 0.07 seconds
hive (nettrom_growth)> DROP TABLE homepagemodule_05;
OK
Time taken: 0.069 seconds
hive (nettrom_growth)> SELECT * FROM homepage_helppanel_backup LIMIT 5;
FAILED: SemanticException [Error 10001]: Line 1:14 Table not found 'homepage_helppanel_backup'
hive (nettrom_growth)> SELECT * FROM homepagevisit_05 LIMIT 5;
FAILED: SemanticException [Error 10001]: Line 1:14 Table not found 'homepagevisit_05'
hive (nettrom_growth)> SELECT * FROM homepagemodule_05 LIMIT 5;
FAILED: SemanticException [Error 10001]: Line 1:14 Table not found 'homepagemodule_05'
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits