We are working on automating the ETL that will load the latest monthly pageviews snapshot in wmf_product database in T291956. For that we need the wmf_product.pageviews_corrected and wmf_product.gs_pageviews_corrected table to be owned by analytics-product user.
The job is scheduled to be run on Nov 9. Can you please change ownership of the table before Nov 8, 2021 ?
Thank you and please reach out for questions.
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Mayakp.wiki | T288677 Enable movement metric calculation as analytics-product user | |||
| Resolved | Mayakp.wiki | T291956 Migrate 'Readers' Key Product Metrics notebooks to analytics/wmf-product/jobs | |||
| Resolved | BTullis | T295084 Change ownership of pageviews_corrected |
I have made that change for you Maya.
btullis@an-launcher1002:~$ sudo -u hdfs kerberos-run-command hdfs hdfs dfs -chown -R analytics-product /user/hive/warehouse/wmf_product.db/pageviews_corrected/ btullis@an-launcher1002:~$ sudo -u hdfs kerberos-run-command hdfs hdfs dfs -ls /user/hive/warehouse/wmf_product.db/pageviews_corrected/ Found 6 items drwxr-xr-- - analytics-product analytics-privatedata-users 0 2021-08-06 21:27 /user/hive/warehouse/wmf_product.db/pageviews_corrected/year=2016 drwxr-xr-- - analytics-product analytics-privatedata-users 0 2021-08-06 21:24 /user/hive/warehouse/wmf_product.db/pageviews_corrected/year=2017 drwxr-xr-- - analytics-product analytics-privatedata-users 0 2021-08-06 21:23 /user/hive/warehouse/wmf_product.db/pageviews_corrected/year=2018 drwxr-xr-- - analytics-product analytics-privatedata-users 0 2021-08-06 21:21 /user/hive/warehouse/wmf_product.db/pageviews_corrected/year=2019 drwxr-xr-- - analytics-product analytics-privatedata-users 0 2021-08-06 21:19 /user/hive/warehouse/wmf_product.db/pageviews_corrected/year=2020 drwxr-xr-- - analytics-product analytics-privatedata-users 0 2021-10-08 21:07 /user/hive/warehouse/wmf_product.db/pageviews_corrected/year=2021
Please do let me know if you have any issues before or after the job runs.
Thanks @BTullis ! Can you pls also change ownership of the gs_pageviews_corrected table to analytics-product user?
Sorry for not adding this request earlier. We were waiting to get confirmation on a question before we added this change to the scope.
No worries. I've now made that additional change for you.
btullis@an-launcher1002:~$ sudo -u hdfs kerberos-run-command hdfs hdfs dfs -chown -R analytics-product /user/hive/warehouse/wmf_product.db/gs_pageviews_corrected