Coalesce nulls to 0s in output
Closed, ResolvedPublic3 Estimated Story Points
Actions

Assigned To

Authored By

	Milimetric
	Sep 1 2016, 7:09 PM

Description

We store nulls instead of zeroes to save space, so we should coalesce them before out-putting, users like 0s when that's what the null data actually means.

Details

Subject	Repo	Branch	Lines +/-
Map null values to zeros in output in per-article endpoint	analytics/aqs	master	+15 -1
Map null values to zeros in output in per-article endpoint	analytics/aqs	new-aqs-cluster	+15 -1
Map null count values to zeros in output	analytics/aqs	master	+17 -1

Customize query in gerrit

Related Objects
Search...

Status	Assigned	Task
Duplicate	• mobrovac	T125345 Many error 500 from pageviews API "Error in Cassandra table storage backend"
Resolved	JAllemandou	T124314 Better response times on AQS (Pageview API mostly) {melc}
Resolved	elukey	T144497 Switch AQS to new cluster
Resolved	• Nuria	T144521 Coalesce nulls to 0s in output

Event Timeline

Milimetric created this task.Sep 1 2016, 7:09 PM

• Nuria claimed this task.Sep 7 2016, 7:31 PM

• Nuria moved this task from Next Up to In Progress on the Analytics-Kanban board.

Change 309386 had a related patch set uploaded (by Nuria):
Map null count values to zeros in output

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

gerritbot added a project: Patch-For-Review.Sep 8 2016, 8:04 PM

• Nuria moved this task from In Progress to In Code Review on the Analytics-Kanban board.Sep 8 2016, 8:23 PM

Change 309604 had a related patch set uploaded (by Nuria):
Map null count values to zeros in output

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

Change 309386 abandoned by Nuria:
Map null count values to zeros in output

Reason:
Changes on branch, not master.

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

Change 309604 merged by Nuria:
Map null values to zeros in output in per-article endpoint

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

Milimetric moved this task from In Code Review to Ready to Deploy on the Analytics-Kanban board.Sep 15 2016, 2:34 PM

Milimetric moved this task from Ready to Deploy to Done on the Analytics-Kanban board.Sep 15 2016, 3:10 PM

• Nuria closed this task as Resolved.Sep 19 2016, 3:08 PM

Change 314284 had a related patch set uploaded (by Nuria):
Bringing master up to date with aqs-new-cluster branch

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

Change 315284 had a related patch set uploaded (by Elukey):
Map null values to zeros in output in per-article endpoint

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

Change 315284 merged by Nuria:
Map null values to zeros in output in per-article endpoint