Develop HQL Scripts for Creating Global Editor Metrics Cassandra Tables in Hive.
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Snwachukwu
	Nov 17 2025, 4:54 PM

Description

In this task, the HQL script to create and load the following tables in hive should be developed.

The hive table will then be mirrowed to cassandra in another task.

Related Changes in Gerrit:

	Subject	Repo	Branch	Lines +/-
	Add HQL for pageviews_per_editor and pageview_top_pages_per_editor	analytics/refinery	master	+195 -0

Status	Assigned	Task
Open	None	T382442 [Epic] iOS Wikipedia Year in Review 2025 (V3)
Resolved	HNordeenWMF	T388060 [Sub-Epic] [WE 3.2.9] On-device statistics Improvements for Year in Review 2025
Open	None	T341649 Provide an easy way for MediaWiki to fetch aggregate data from the data lake
Open	None	T388455 [Spike] Full-year editing stats for Year in Review
Open	Ottomata	T403660 WE3.3.7 Year in Review and Activity Tab Services - Global Editor Metrics
Open	amastilovic	T405039 Global Editor Metrics - Data Pipeline
Resolved	Snwachukwu	T410289 Develop HQL Scripts for Creating Global Editor Metrics Cassandra Tables in Hive.

Snwachukwu changed the task status from Open to In Progress.Nov 17 2025, 4:55 PM

Snwachukwu updated the task description. (Show Details)

Change #1206879 had a related patch set uploaded (by Snwachukwu; author: Snwachukwu):

[analytics/refinery@master] Add HQL for pageviews_per_editor and pageview_top_pages_per_editor

Snwachukwu closed this task as Resolved.Dec 1 2025, 8:10 PM

Change #1206879 merged by Aleksandar Mastilovic:

[analytics/refinery@master] Add HQL for pageviews_per_editor and pageview_top_pages_per_editor