Page MenuHomePhabricator
Paste P8650

Hive queries to check results of SACK A/B test
ActivePublic
Actions

Authored by • Gilles on Jun 25 2019, 8:27 AM.
Tags
Referenced Files
F29639613: raw.txt
Jun 25 2019, 8:30 AM
F29639607: raw.txt
Jun 25 2019, 8:27 AM
Subscribers
None
SELECT
PERCENTILE(event.loadEventEnd, 0.5) AS median,
PERCENTILE(event.loadEventEnd, 0.9) AS p90,
PERCENTILE(event.loadEventEnd, 0.95) AS p95,
COUNT(*) AS count
FROM event.navigationtiming
WHERE year = 2019
AND month = 6
AND
(
(day = 24 AND hour >= 14)
OR
day = 25
)
AND
(
(INT(SUBSTR(recvfrom, 3, 4)) >= 5001 AND INT(SUBSTR(recvfrom, 3, 4)) <= 5003)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 5007 AND INT(SUBSTR(recvfrom, 3, 4)) <= 5009)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 1075 AND INT(SUBSTR(recvfrom, 3, 4)) <= 1082)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2001 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2002)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2004 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2008)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2010 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2011)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 2014)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 2017)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 3040 AND INT(SUBSTR(recvfrom, 3, 4)) <= 3047)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 3049)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 4024 AND INT(SUBSTR(recvfrom, 3, 4)) <= 4029)
);
SELECT
PERCENTILE(event.loadEventEnd, 0.5) AS median,
PERCENTILE(event.loadEventEnd, 0.9) AS p90,
PERCENTILE(event.loadEventEnd, 0.95) AS p95,
COUNT(*) AS count
FROM event.navigationtiming
WHERE year = 2019
AND month = 6
AND
(
(day = 24 AND hour >= 14)
OR
day = 25
)
AND
(
(INT(SUBSTR(recvfrom, 3, 4)) >= 5004 AND INT(SUBSTR(recvfrom, 3, 4)) <= 5006)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 5010 AND INT(SUBSTR(recvfrom, 3, 4)) <= 5012)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 1083 AND INT(SUBSTR(recvfrom, 3, 4)) <= 1090)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2012 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2013)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 2018 AND INT(SUBSTR(recvfrom, 3, 4)) <= 2026)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 2016)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 3032 AND INT(SUBSTR(recvfrom, 3, 4)) <= 3039)
OR
(INT(SUBSTR(recvfrom, 3, 4)) == 3030)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 4021 AND INT(SUBSTR(recvfrom, 3, 4)) <= 4023)
OR
(INT(SUBSTR(recvfrom, 3, 4)) >= 4030 AND INT(SUBSTR(recvfrom, 3, 4)) <= 4032)
);
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL