Page MenuHomePhabricator
Paste P8767

Create table `toledo_pageviews`
ActivePublic

Authored by chelsyx on Jul 17 2019, 8:29 PM.
Tags
None
Referenced Files
F29802782: raw.txt
Jul 18 2019, 8:21 PM
F29802482: raw.txt
Jul 18 2019, 7:59 PM
F29792834: raw.txt
Jul 17 2019, 8:29 PM
Subscribers
DROP TABLE IF EXISTS neilpquinn.toledo_pageviews;
CREATE EXTERNAL TABLE IF NOT EXISTS neilpquinn.toledo_pageviews
(
`count` bigint COMMENT 'pageview count',
`year` int COMMENT 'Unpadded year of request',
`month` int COMMENT 'Unpadded month of request',
`day` int COMMENT 'Unpadded day of request',
`http_method` string COMMENT 'HTTP method',
`http_status` int COMMENT 'HTTP status',
`uri_host` string COMMENT 'URI host',
`agent_type` string COMMENT 'user agent type',
`access_method` string COMMENT 'Method used to accessing the site (mobile web|desktop)',
`referer_host` string COMMENT 'Host from referer parsing',
`referer_class` string COMMENT 'Indicates if a referer is internal, external or unknown.',
`client_srp` boolean COMMENT 'Whether client is search result page from referer parsing',
`home_language` string COMMENT 'Home language',
`source_language` string COMMENT 'Source language',
`to_language` string COMMENT 'To language',
`rurl_param` string COMMENT 'rurl parameter',
`continent` string COMMENT 'Continent of the accessing agents (maxmind GeoIP database)',
`country_code` string COMMENT 'Country iso code of the accessing agents (maxmind GeoIP database)',
`country` string COMMENT 'Country (text) of the accessing agents (maxmind GeoIP database)'
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
LOCATION '/user/neilpquinn-wmf/toledo_pageviews/daily'
;