Page MenuHomePhabricator
Create Task
Maniphest T305556

Drop UploadWizard* data
Closed, ResolvedPublic
Actions

Description

Per T305238: Decommission the UploadWizard* instruments, the following tables should be dropped:

[0]
show tables in event_sanitized like 'uploadwizard*';

uploadwizarderrorflowevent
uploadwizardexceptionflowevent
uploadwizardflowevent
uploadwizardstep
uploadwizardtutorialactions
uploadwizarduploadflowevent
In T305238#7957150, @Ottomata wrote:

@phuedx Should we also remove the current tables and data in the event database? There doesn't seem to be much there anyway :)

[1]
show tables in event like 'uploadwizard*';

uploadwizarderrorflowevent
uploadwizardexceptionflowevent
uploadwizardflowevent
uploadwizardstep
uploadwizardtutorialactions
uploadwizarduploadflowevent
Related Objects
Search...
Event Timeline
phuedx created this task.Apr 6 2022, 2:38 PM
Restricted Application added a subscriber: Aklapper.  ·  View Herald TranscriptApr 6 2022, 2:38 PM
phuedx mentioned this in T305238: Decommission the UploadWizard* instruments.Apr 6 2022, 2:39 PM
EChetty moved this task from Incoming to Requests on the Data-Engineering board.Apr 24 2022, 7:12 AM
Ottomata moved this task from Requests to Ops Week on the Data-Engineering board.May 11 2022, 6:32 PM
phuedx removed a parent task: T305238: Decommission the UploadWizard* instruments.Thu, May 26, 9:07 AM
phuedx added a subtask: T305238: Decommission the UploadWizard* instruments.
phuedx closed subtask T305238: Decommission the UploadWizard* instruments as Resolved.
phuedx renamed this task from Drop sanitized UploadWizard* data to Drop UploadWizard* data.Thu, May 26, 9:11 AM
phuedx updated the task description. (Show Details)
phuedx added a subscriber: Ottomata.
phuedx added a comment.Thu, May 26, 9:24 AM


In T305238#7957150, @Ottomata wrote:


@phuedx Should we also remove the current tables and data in the event database?  There doesn't seem to be much there anyway :)





@MarkTraceur, as the manager for the team that owned the instrument, could you confirm that these tables can be dropped?
MarkTraceur added a comment.Thu, May 26, 9:00 PM
Yeah, it should be okay to drop the tables at this point. I don't see much need to keep them around.
Milimetric claimed this task.Tue, May 31, 7:02 PM
Milimetric added a project: Data-Engineering-Kanban.
Milimetric moved this task from Next Up to Ready to Deploy on the Data-Engineering-Kanban board.Tue, May 31, 7:20 PM
Milimetric moved this task from Ready to Deploy to Done on the Data-Engineering-Kanban board.EditedTue, May 31, 8:24 PM



drop table event_sanitized.uploadwizarderrorflowevent;
drop table event_sanitized.uploadwizardexceptionflowevent;
drop table event_sanitized.uploadwizardflowevent;
drop table event_sanitized.uploadwizardstep;
drop table event_sanitized.uploadwizardtutorialactions;
drop table event_sanitized.uploadwizarduploadflowevent;

drop table event.uploadwizarderrorflowevent;
drop table event.uploadwizardexceptionflowevent;
drop table event.uploadwizardflowevent;
drop table event.uploadwizardstep;
drop table event.uploadwizardtutorialactions;
drop table event.uploadwizarduploadflowevent;

sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -r /wmf/data/event_sanitized/uploadwizarderrorflowevent
sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -r /wmf/data/event_sanitized/uploadwizardexceptionflowevent
sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -r /wmf/data/event_sanitized/uploadwizardflowevent
sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -r /wmf/data/event_sanitized/uploadwizardstep
sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -r /wmf/data/event_sanitized/uploadwizardtutorialactions
sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -r /wmf/data/event_sanitized/uploadwizarduploadflowevent

sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -r /wmf/data/event/uploadwizarderrorflowevent
sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -r /wmf/data/event/uploadwizardexceptionflowevent
sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -r /wmf/data/event/uploadwizardflowevent
sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -r /wmf/data/event/uploadwizardstep
sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -r /wmf/data/event/uploadwizardtutorialactions
sudo -u analytics kerberos-run-command analytics hdfs dfs -rm -r /wmf/data/event/uploadwizarduploadflowevent
Milimetric closed this task as Resolved.Thu, Jun 9, 7:03 PM
Milimetric triaged this task as Medium priority.
Content licensed under Creative Commons Attribution-ShareAlike 3.0 (CC-BY-SA) unless otherwise noted; code licensed under GNU General Public License (GPL) or 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