raw.txt
No One
Actions

Authored By

	• chelsyx
	Jul 17 2019, 8:29 PM

Size

1 KB

Referenced Files

None

Subscribers

None

raw.txt
View Options

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