Page MenuHomePhabricator
Create Task
Maniphest T255222

'namespace_is_content' column in pageview data returns 1, 0 and NULL as booleans in Superset/Turnilo
Closed, ResolvedPublic1 Estimated Story Points
Actions

Description

'namespace_is_content' column from pageview_hourly and pageview_daily in Superse/Turnilo returns 1, 0 or NULL as boolean. While 'namespace_is_talk' in the same table returns TRUE, FALSE and NULL as well as boolean column in other tables. Can this column be made consistent with others?

Screen Shot 2020-06-11 at 9.12.43 PM.png (790×1 px, 129 KB)

Details

SubjectRepoBranchLines +/-
Update namespace_is_content field in druid pageviewanalytics/refinerymaster+3 -3
Customize query in gerrit

Event Timeline

cchen renamed this task from 'namespace_is_content' column from pageview_hourly and pageview_daily returns 1, 0 and NULL as booleans in Superset/Turnilo to 'namespace_is_content' column in pageview data returns 1, 0 and NULL as booleans in Superset/Turnilo.Jun 12 2020, 1:19 AM
cchen created this task.
cchen moved this task from Triage to Tracking on the Product-Analytics board.
• fdans added a project: Analytics-Kanban.Jun 15 2020, 3:46 PM
• fdans moved this task from Incoming to Smart Tools for Better Data on the Analytics board.
JAllemandou claimed this task.Jun 30 2020, 9:50 AM
JAllemandou set Final Story Points to 1.
JAllemandou moved this task from Next Up to In Code Review on the Analytics-Kanban board.
gerritbot added a comment.Jun 30 2020, 9:55 AM

Change 608576 had a related patch set uploaded (by Joal; owner: Joal):
[analytics/refinery@master] Update namespace_is_content field in druid pageview

https://gerrit.wikimedia.org/r/c/analytics/refinery/ /608576

gerritbot added a project: Patch-For-Review.Jun 30 2020, 9:55 AM
gerritbot added a comment.Jun 30 2020, 2:02 PM

Change 608576 merged by Ottomata:
[analytics/refinery@master] Update namespace_is_content field in druid pageview

https://gerrit.wikimedia.org/r/c/analytics/refinery/ /608576

JAllemandou moved this task from In Code Review to Ready to Deploy on the Analytics-Kanban board.Jun 30 2020, 4:28 PM
Maintenance_bot removed a project: Patch-For-Review.Jul 1 2020, 7:08 PM
JAllemandou moved this task from Ready to Deploy to Done on the Analytics-Kanban board.Jul 2 2020, 12:52 PM
• Nuria closed this task as Resolved.Jul 6 2020, 5:52 PM
• Nuria set the point value for this task to 1.
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