Addshore added a subscriber: JAllemandou. Addshore added a comment.
In T248592#6002784 <https://phabricator.wikimedia.org/T248592#6002784>, @Marostegui wrote: > So as far as I understand and from https://gerrit.wikimedia.org/r/583693 > The view `wb_terms_no_longer_updated` will point to `wb_terms` As I understand it yes > The current `wb_terms` view points to `wb_terms`. I thought you wanted to, at some point, truncate `wb_terms`. If that happens and you want people to still be able to query old `wb_terms` data, we'd need to: > > - Rename wb_terms table to maybe: `wb_terms_no_longer_updated` and re-point the view `wb_terms_no_longer_updated` to that "new" table. > - Create an empty `wb_terms` table with the same structure. `wb_terms` view will keep pointing to this now empty table. wb_terms in the cloud replicas for wikidatawiki_p is a view though? Or did I get that wrong? If it is a view then we just remove that view and create a new table in wikidatawiki_p called wb_terms that is empty? If it is not a view then we must do some more things. In T248592#6002790 <https://phabricator.wikimedia.org/T248592#6002790>, @Bstorm wrote: > I would prefer the table rename be done, then the views can be adjusted so that wb_terms and wb_terms_no_longer_updated both are in the "fullviews" key in the yaml. That will make it clear there is no filtering or other whatnot going on. > In the patch I put up both wb_terms and wb_terms_no_longer_updated will point to wb_terms until the rename and empty table. If this is the desired approach then we can coordinate this on Monday (or chat tomorrow Friday) :) In T248592#6002823 <https://phabricator.wikimedia.org/T248592#6002823>, @Bstorm wrote: > Look good now @Addshore and @Marostegui ? Yup! | wb_terms | | wb_terms_no_longer_updated | | wbc_entity_usage | | wbqc_constraints | | wbs_propertypairs | | wbt_item_terms | | wbt_property_terms | | wbt_term_in_lang | | wbt_text | | wbt_text_in_lang | | wbt_type | +----------------------------+ 107 rows in set (0.00 sec) MariaDB [wikidatawiki_p]> select * from wb_terms_no_longer_updated limit 1; +-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+ | term_row_id | term_entity_id | term_full_entity_id | term_entity_type | term_language | term_type | term_text | term_search_key | term_weight | +-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+ | 363474 | 50445 | Q50445 | item | en-gb | label | Jungwon-gu | | 0 | +-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+ 1 row in set (0.01 sec) MariaDB [wikidatawiki_p]> select * from wb_terms limit 1; +-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+ | term_row_id | term_entity_id | term_full_entity_id | term_entity_type | term_language | term_type | term_text | term_search_key | term_weight | +-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+ | 363474 | 50445 | Q50445 | item | en-gb | label | Jungwon-gu | | 0 | +-------------+----------------+---------------------+------------------+---------------+-----------+------------+-----------------+-------------+ 1 row in set (0.00 sec) In T248592#6002918 <https://phabricator.wikimedia.org/T248592#6002918>, @Marostegui wrote: > @Addshore maybe this is not the right task to ask for it but...is Analytics aware of this change? They use labsdb1012 to sqoop data the first days of the month. I believe the sqooping of these tables only happens because of a desire by WMDE I'll make sure we turn this off on Friday! Ping @JAllemandou :) TASK DETAIL https://phabricator.wikimedia.org/T248592 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: Addshore Cc: JAllemandou, Bstorm, Marostegui, WMDE-leszek, Aklapper, Addshore, Phamhi, Iflorez, darthmon_wmde, Nandana, sietec, Lahi, Gq86, GoranSMilovanovic, Chicocvenancio, Allthingsgo, QZanden, LawExplorer, Minhnv-2809, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331, Jay8g, bd808, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs