Milimetric has uploaded a new change for review. ( https://gerrit.wikimedia.org/r/365809 )
Change subject: Clean up comments from create table statement ...................................................................... Clean up comments from create table statement Change-Id: Ifc3e76ff8cc4c172debfca5aab56e5b75e2ca660 --- M hive/mediawiki/history/create_mediawiki_history_table.hql 1 file changed, 5 insertions(+), 11 deletions(-) git pull ssh://gerrit.wikimedia.org:29418/analytics/refinery refs/changes/09/365809/1 diff --git a/hive/mediawiki/history/create_mediawiki_history_table.hql b/hive/mediawiki/history/create_mediawiki_history_table.hql index a04a494..5af0d19 100644 --- a/hive/mediawiki/history/create_mediawiki_history_table.hql +++ b/hive/mediawiki/history/create_mediawiki_history_table.hql @@ -12,8 +12,7 @@ `wiki_db` string COMMENT 'enwiki, dewiki, eswiktionary, etc.', `event_entity` string COMMENT 'revision, user or page', `event_type` string COMMENT 'create, move, delete, etc. Detailed explanation in the docs under #Event_types', - `event_timestamp` string COMMENT 'When this event ocurred', - --`event_timestamp` timestamp COMMENT 'When this event ocurred', + `event_timestamp` timestamp COMMENT 'When this event ocurred', `event_comment` string COMMENT 'Comment related to this event, sourced from log_comment, rev_comment, etc.', `event_user_id` bigint COMMENT 'Id of the user that caused the event', `event_user_text` string COMMENT 'Historical text of the user that caused the event', @@ -27,11 +26,9 @@ `event_user_is_created_by_peer` boolean COMMENT 'Whether the event_user account was created by another user', `event_user_is_anonymous` boolean COMMENT 'Whether the event_user is not registered', `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` string COMMENT 'Registration timestamp of the user that caused the event', - --`event_user_creation_timestamp` timestamp COMMENT 'Registration timestamp of the user that caused the event', + `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)', - `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', @@ -41,8 +38,7 @@ `page_namespace_latest` int COMMENT 'In revision/page events: current namespace of the page', `page_namespace_is_content_latest` boolean COMMENT 'In revision/page events: current namespace of the page is categorized as content', `page_is_redirect_latest` boolean COMMENT 'In revision/page events: whether the page is currently a redirect', - `page_creation_timestamp` string COMMENT 'In revision/page events: creation timestamp of the page', - --`page_creation_timestamp` timestamp COMMENT 'In revision/page events: creation timestamp of the page', + `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)', @@ -58,8 +54,7 @@ `user_is_created_by_peer` boolean COMMENT 'In user events: whether the user account was created by another user', `user_is_anonymous` boolean COMMENT 'In user events: whether the user is not registered', `user_is_bot_by_name` boolean COMMENT 'In user events: whether the user\'s name matches patterns we use to identify bots', - `user_creation_timestamp` string COMMENT 'In user events: registration timestamp of the user.', - --`user_creation_timestamp` timestamp COMMENT 'In user events: registration timestamp of the user.', + `user_creation_timestamp` timestamp COMMENT 'In user events: registration timestamp of the user.', `revision_id` bigint COMMENT 'In revision events: id of the revision', `revision_parent_id` bigint COMMENT 'In revision events: id of the parent revision', @@ -70,8 +65,7 @@ `revision_content_model` string COMMENT 'In revision events: content model of revision', `revision_content_format` string COMMENT 'In revision events: content format of revision', `revision_is_deleted` boolean COMMENT 'In revision events: whether this revision has been deleted (moved to archive table)', - `revision_deleted_timestamp` string COMMENT 'In revision events: the timestamp when the revision was deleted', - --`revision_deleted_timestamp` timestamp COMMENT 'In revision events: the timestamp when the revision was deleted', + `revision_deleted_timestamp` timestamp COMMENT 'In revision events: the timestamp when the revision was deleted', `revision_is_identity_reverted` boolean COMMENT 'In revision events: whether this revision was reverted by another future revision', `revision_first_identity_reverting_revision_id` bigint COMMENT 'In revision events: id of the revision that reverted this revision', `revision_seconds_to_identity_revert` bigint COMMENT 'In revision events: seconds elapsed between revision posting and its revert (if there was one)', -- To view, visit https://gerrit.wikimedia.org/r/365809 To unsubscribe, visit https://gerrit.wikimedia.org/r/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ifc3e76ff8cc4c172debfca5aab56e5b75e2ca660 Gerrit-PatchSet: 1 Gerrit-Project: analytics/refinery Gerrit-Branch: master Gerrit-Owner: Milimetric <[email protected]> _______________________________________________ MediaWiki-commits mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
