Joal has submitted this change and it was merged. ( https://gerrit.wikimedia.org/r/373249 )
Change subject: Correct mediawiki_history hive table create script ...................................................................... Correct mediawiki_history hive table create script A typo was present in two names preventing accessing data correctly. Change-Id: I016cc5e6643c1775c30c230bd047d73e97e0f064 --- M hive/mediawiki/history/create_mediawiki_history_table.hql 1 file changed, 2 insertions(+), 2 deletions(-) Approvals: Joal: Verified; Looks good to me, approved diff --git a/hive/mediawiki/history/create_mediawiki_history_table.hql b/hive/mediawiki/history/create_mediawiki_history_table.hql index 5af0d19..8d4ce62 100644 --- a/hive/mediawiki/history/create_mediawiki_history_table.hql +++ b/hive/mediawiki/history/create_mediawiki_history_table.hql @@ -28,7 +28,7 @@ `event_user_is_bot_by_name` boolean COMMENT 'Whether the event_user\'s name matches patterns we use to identify bots', `event_user_creation_timestamp` timestamp COMMENT 'Registration timestamp of the user that caused the event', `event_user_revision_count` bigint COMMENT 'Cumulative revision count per user for the current event_user_id (only available in revision-create events so far)', - `event_user_seconds_to_previous_revision` bigint COMMENT 'In revision events: seconds elapsed since the previous revision made by the current event_user_id (only available in revision-create events so far)', + `event_user_seconds_from_previous_revision` bigint COMMENT 'In revision events: seconds elapsed since the previous revision made by the current event_user_id (only available in revision-create events so far)', `page_id` bigint COMMENT 'In revision/page events: id of the page', `page_title` string COMMENT 'In revision/page events: historical title of the page', @@ -40,7 +40,7 @@ `page_is_redirect_latest` boolean COMMENT 'In revision/page events: whether the page is currently a redirect', `page_creation_timestamp` timestamp COMMENT 'In revision/page events: creation timestamp of the page', `page_revision_count` bigint COMMENT 'In revision/page events: Cumulative revision count per page for the current page_id (only available in revision-create events so far)', - `page_seconds_to_previous_revision` bigint COMMENT 'In revision/page events: seconds elapsed since the previous revision made on the current page_id (only available in revision-create events so far)', + `page_seconds_from_previous_revision` bigint COMMENT 'In revision/page events: seconds elapsed since the previous revision made on the current page_id (only available in revision-create events so far)', `user_id` bigint COMMENT 'In user events: id of the user', `user_text` string COMMENT 'In user events: historical user text', -- To view, visit https://gerrit.wikimedia.org/r/373249 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: merged Gerrit-Change-Id: I016cc5e6643c1775c30c230bd047d73e97e0f064 Gerrit-PatchSet: 1 Gerrit-Project: analytics/refinery Gerrit-Branch: master Gerrit-Owner: Joal <[email protected]> Gerrit-Reviewer: Joal <[email protected]> Gerrit-Reviewer: Ottomata <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
