Create table `toledo_pageviews`
ActivePublic
Actions

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'
	;

Create table `toledo_pageviews`ActivePublicActions