zero.hql
Ironholds (Oliver Keyes)
Actions

Authored By

	Ironholds
	May 6 2015, 4:21 PM

Size

671 B

Referenced Files

None

Subscribers

None

zero.hql
View Options

	SET hive.mapred.mode=nonstrict;

	USE wmf;
	SELECT x_analytics_map['zero'] AS zero_mcc, COUNT(*) AS requests
	FROM webrequest
	WHERE year = 2015
	AND month = 04
	AND ((day = 20 AND hour = 3) OR (day = 21 AND hour = 9) OR (day = 23 AND hour = 23) OR (day = 25 AND hour = 15)
	OR (day = 25 AND hour = 18))
	AND webrequest_source IN('text','mobile')
	AND content_type IN('text/html\; charset=ISO-8859-1',
	'text/html',
	'text/html\; charset=utf-8',
	'text/html\; charset=UTF-8')
	AND http_status IN('200','304')
	AND uri_host IN('www.wikipedia.org','www.m.wikipedia.org')
	GROUP BY x_analytics_map['zero']
	ORDER BY requests DESC;

File Metadata

Mime Type: text/plain
Storage Engine: blob
Storage Format: Raw Data
Storage Handle: 156865
Default Alt Text: zero.hql (671 B)

Event Timeline