Joal has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/373268 )
Change subject: Update wdqs_extract hive table create script
......................................................................
Update wdqs_extract hive table create script
This table reflects webrequest and therefore needed the updated
version of normalized_host with project_family.
Change-Id: I338ff8e758a4916e4e96be347d1f82395537cef3
---
M hive/wikidata/create_wdqs_extract_table.hql
1 file changed, 1 insertion(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/analytics/refinery
refs/changes/68/373268/1
diff --git a/hive/wikidata/create_wdqs_extract_table.hql
b/hive/wikidata/create_wdqs_extract_table.hql
index 9b86ef4..6d38f9e 100644
--- a/hive/wikidata/create_wdqs_extract_table.hql
+++ b/hive/wikidata/create_wdqs_extract_table.hql
@@ -51,7 +51,7 @@
`agent_type` string COMMENT 'Categorise the agent making the
webrequest as either user or spider (automatas to be added).',
`is_zero` boolean COMMENT 'Indicates if the webrequest is
accessed through a zero provider',
`referer_class` string COMMENT 'Indicates if a referer is internal,
external or unknown.',
- `normalized_host` struct<project_class: string, project:string,
qualifiers: array<string>, tld: String> COMMENT 'struct containing
project_class (such as wikipedia or wikidata for instance), project (such as en
or commons), qualifiers (a list of in-between values, such as m and/or zero)
and tld (org most often)',
+ `normalized_host` struct<project_class: string, project_family: string,
project:string, qualifiers: array<string>, tld: String> COMMENT 'struct
containing project_class (such as wikipedia or wikidata for instance), project
(such as en or commons), qualifiers (a list of in-between values, such as m
and/or zero) and tld (org most often)',
`pageview_info` map<string, string> COMMENT 'map containing project,
language_variant and page_title values only when is_pageview = TRUE.',
`page_id` int COMMENT 'MediaWiki page_id for this page
title. For redirects this could be the page_id of the redirect or the page_id
of the target. This may not always be set, even if the page is actually a
pageview.'
)
--
To view, visit https://gerrit.wikimedia.org/r/373268
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I338ff8e758a4916e4e96be347d1f82395537cef3
Gerrit-PatchSet: 1
Gerrit-Project: analytics/refinery
Gerrit-Branch: master
Gerrit-Owner: Joal <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
