fr_pending_hourly
Bug: T362615
The MR adds two file
- Table creation:
create_fr_pending_hourly_table.hql
(tested) - Hourly calculation query:
calculate_fr_pending_hourly.sql
- This is slightly different from the recommended testing, as this will be run using MySQL
- Deletion / insertion will be part of the DAG script.
- Link to the DAG script (being tested): https://gitlab.wikimedia.org/kcvelaga/airflow-dags/-/blob/frevs_pending/analytics_product/dags/flagged_revisions/fr_pending_hourly.py?ref_type=heads
- I have tested the query, and the results are available at
kcvelaga.fr_pending_hourly
Note: I closed the previous MR as due to schema changes lately.