WikiLambda metrics: Create wikilambda_zobject_join table in Hive
Open, In Progress, MediumPublic
Actions

Assigned To

Authored By

	DMartin-WMF
	Apr 25 2024, 5:20 AM

Description

Provide an hql script (in the analytics/refinery repo) that creates the wikilambda_zobject_join (*) table in Hive. The table will receive sqoop output periodically, extracted from the WikiLambda table wikilambda_zobject_join (*).

(*) or whatever table name finally results from the work on T357552

See T341728 for an example of previous similar work.

Completion checklist

Before closing this task, review one by one the checklist available here: https://www.mediawiki.org/wiki/Abstract_Wikipedia_team/Definition_of_Done#Front-end_Task/Bug_Completion_Checklist

Details

	Subject	Repo	Branch	Lines +/-
	Create wikilambda_zobject_join table in HQL	analytics/refinery	master	+32 -0

Customize query in gerrit

Related Objects
Search...

Status	Assigned	Task
Open	None	T356027 WikiLambda metrics: 2023/24 suggested new metrics
Open	None	T355637 WikiLambda metrics: collect type usage for run-function requests
Open	DMartin-WMF	T355638 WikiLambda metrics: track types usage for inputs/outputs of functions
Open	None	T355923 WikiLambda metrics: Track inventory & uses of "type support" functions
In Progress	DMartin-WMF	T363439 [24Q4] WikiLambda Metrics: Create DB table wikilambda_zobject_join & make it available in Analytics Data Lake
Open	None	T368103 Data QA of wikilambda_zobject_join table
In Progress	ecarg	T363436 WikiLambda metrics: Create wikilambda_zobject_join table in Hive