Page MenuHomePhabricator

No longer use removed cuc_actiontext column in analytics/refinery
Closed, ResolvedPublic1 Estimated Story Points

Description

The cuc_actiontext column has been removed from the cu_changes table. Therefore it needs to be no longer used in the queries in sqoop.py in analytics/refinery.

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Event Timeline

Change #1057221 had a related patch set uploaded (by Dreamy Jazz; author: Dreamy Jazz):

[analytics/refinery@master] Don't select cuc_actiontext from cu_changes for sqoop

https://gerrit.wikimedia.org/r/1057221

Adding this to our Sprint board as it needs to get a look and deployment. But the change looks good, just have to alter the table and make sure the timing of all the jobs works out.

this got lost in the sprint move and almost broke a bunch of stuff, but I had a nightmare about it so it's all good

Change #1057221 merged by Milimetric:

[analytics/refinery@master] Don't select cuc_actiontext from cu_changes for sqoop

https://gerrit.wikimedia.org/r/1057221

I have deployed this so it should be picked up by the job that starts on Sep. 1st. I have not dropped the column out of the table because old data is deleted quickly anyway and it doesn't hurt the insert.